Melanie, Make sure you check the SQL Library on the Wiki - http://wiki.koha.org/doku.php?id=sql_library And Chris, Make sure you add your report to the SQL Library on the Wiki - http://wiki.koha.org/doku.php?id=sql_library :) hehe Nicole (the nagging documentation manager) On Tue, Oct 27, 2009 at 1:20 PM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
2009/10/28 Melanie Hedgespeth <melanie@salpublib.org>
I need to create a report that lists the total number of holds placed for a month’s period. (Able to separate that by library)
Any tips on how I go about this?
Hi Melanie
Something like
SELECT count(*),branchcode FROM reserves WHERE reservedate >= '2009-09-01' AND reservedate <= '2009-09-30' GROUP BY branchcode
Oughta work
Chris _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha