[Koha] SQL report [of number of issues]

[Owen Leonard]

> SELECT count(*) FROM statistics WHERE type = 'issue' AND datetime >
> '2008-04-30' AND datetime < '2008-05-01'

Comparing this method with Josh's instructions for running the report in Koha:

Koha reports 40705 circulations for all branches during the month of July 2008.

I ran this query in mysql:

select count(*) from statistics WHERE type = 'issue' AND datetime >
'2008-06-30' AND datetime < '2008-08-01';

...and got 44227. It looks like the reports interface in Koha is using
the same logic as the SQL statement, so if you choose "Jul 1" through
"Jul 31" on the date-pickers the report will not include circulations
from those dates. Selecting "June 30" and "Aug. 1" as the start and
end dates produces results that match the SQL.

  -- Owen

-- 
Web Developer
Athens County Public Libraries
http://www.myacpl.org