[Koha] Holds report

[Chris Cormack]

2009/10/28 Melanie Hedgespeth <melanie at 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