[Koha] Holds report

David Schuster dschust1 at tx.rr.com
Fri Oct 30 02:54:42 NZDT 2009


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 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
>>
> _______________________________________________
> Koha mailing list
> Koha at 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.



More information about the Koha mailing list