A couple years ago Jesse Weaver came up with this report for active
borrowers (i.e., patrons checking out materials):
SELECT YEAR(issuedate), MONTH(issuedate), categorycode,
COUNT(DISTINCT borrowernumber)
FROM old_issues
LEFT JOIN borrowers USING (borrowernumber)
GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode;
I'm wondering if the caveat he notes is still true:
Because it uses old_issues, it won't include anything that's still
checked out; getting
around that requires either ugly subqueries or running the report
with old_issues
and issues and manually combining the results.
Is there a relatively easy way to modify the report so it includes
patrons who may still have items checked out?
Thanks for any assistance!
Cab Vinton, Director
Sanbornton Public Library
Sanbornton, NH
"Politeness and consideration for others is like investing pennies and
getting dollars back." Thomas Sowell
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
