[Koha] Holds report

[Nicole Engard]

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 at bigballofwax.co.nz> wrote:
> 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
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>