Monday Minutes: Library Card Sign-up Month Reports

by Jessie Zairo on Sep 9, 2024

In this week's Monday Minutes, Nick and Jessie talk about ways you can use reports for National Library Card Sign-up Month!

We will share some example reports below that cover the basics of new patrons in a category,

Count of New Patrons by Category in Date Range

SELECT categorycode, COUNT(borrowernumber) AS 'new patrons'

FROM (SELECT borrowernumber, categorycode, dateenrolled FROM borrowers

UNION ALL

SELECT borrowernumber, categorycode, dateenrolled FROM deletedborrowers) AS patrons

WHERE dateenrolled BETWEEN <<Added BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>

GROUP BY categorycode

Count of new patrons by branch, category - select dates

SELECT branchcode, categorycode, COUNT(branchcode) AS NumberEnrolled

FROM borrowers

WHERE dateenrolled BETWEEN <<Added BETWEEN (yyyy-mm-dd)|date>>

AND <<and (yyyy-mm-dd)|date>> and branchcode like <<Branch|branches:all>> and categorycode like <<Category|categorycode:all>>

GROUP BY branchcode, categorycode

WITH ROLLUP

New Patrons Listed by Branch

SELECT categorycode, borrowernumber

FROM (SELECT borrowernumber, categorycode, dateenrolled, branchcode FROM borrowers

UNION ALL

SELECT borrowernumber, categorycode, dateenrolled, branchcode FROM deletedborrowers) AS patrons

WHERE dateenrolled BETWEEN <<Added BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND

branchcode = <<Branch|branches>>

Additional Resources

Monday Minutes: Chart Feature in Report

Self Paced Learning in Koha: Reports