Nag away! Sometimes that's the only way to get people to do stuff! At least that's what I think my wife thinks...;) David Nicole Engard-2 wrote:
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
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Holds-report-tp26083314p26113490.html Sent from the Koha - Discuss mailing list archive at Nabble.com.