2019-01-28 RPWG Meeting notes
Date
Attendees
Notes from Past Meetings (November 2018 - January 2019)
20181107
Reporting Prototype Meeting
-to connect to database on Glint server, give Nassib IP address you will connect from in a direct message to Nassib (for security purposes)
-can connect from your reporting application of choice
-Nassib working on setting up a way to allow HTTP request for results of report/query
-this is a suggested view, but would be interesting to use different views of the data
-would be helpful to try with and without crosstab
The dataset
-sample data created with this report in mind
-approx 50 transactions with user, loan, date, patron group
Questions
-how is the distribution of the data, should it be different for the query?
-do you have any feedback, questions, how is the process working?
-Sharon: BIRT
-Angela: Tableau, R, PGAdmin
-Tod: Aqua Data Studio, maybe something additional
-Kevin: MS Access, Excel, Crystal Reports
For background, see https://folio-org.atlassian.net/wiki/display/RPT/Building+Report+Prototypes
create view v as
select '2017-01-01 - 2018-12-31' as checkout_date_range,
*,
coalesce(faculty, 0) +
coalesce(graduate, 0) +
coalesce(staff, 0) +
coalesce(undergrad, 0) as total_for_library
from crosstab(
'select li.location_name, g.groupname, count(l.id) as ct
from (
select * from loans
where loan_date >= ''2017-01-01'' and loan_date <= ''2018-12-31''
) l
left join loans_item li
on l.id = li.loan_id
left join users u