Re: [Koha] SQL report [of number of issues]

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.