[Koha] SQL report [of number of issues]

Rick Welykochy rick at praxis.com.au
Sat Dec 6 21:11:50 NZDT 2008


Katharine Dixon wrote:

> Hello, I am new to the list so sorry if this has been asked before but 
> does anybody have the SQL for a report that would just give me a total 
> of all */items/* circulated on a certain day.  Just the number, no 
> titles or types.

If by circulated you mean issued/withdrawn:

select count(*) from issues where issuedate = '2008-04-30';



cheers
rickw


-- 
_________________________________
Rick Welykochy || Praxis Services

Finster's Law: A closed mouth gathers no feet.


More information about the Koha mailing list