[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