[Koha] Circulation report w/ each item

[Wagner, Jane]

Maybe something like this:

SELECT statistics.datetime, items.itemcallnumber FROM statistics LEFT
JOIN items on (items.itemnumber = statistics.itemnumber) WHERE
statistics.type = 'issue' AND statistics.datetime >=
concat(date_format(LAST_DAY(now() - interval 1 month),'%Y-%m-'),'01')
AND statistics.datetime <= LAST_DAY(now() - interval 1 month) ORDER BY
items.cn_sort asc

This will run for whatever the month before today is.  If you want
hardcoded dates, you can substitute them for the datetime => and <=
where statements.

Note that when I tried this on a production server, the number of
entries easily exceeded Koha's dratted 10,000-line download limit. See
the bugzilla entry for that problem and workaround:

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 

Jane Wagner
Library Systems Analyst
PTFS Inc.
Content Management and Library Solutions
6400 Goldsboro Road, Suite 200
Bethesda, MD  20817
(301) 654-8088 x 151
jwagner at ptfs.com


-----Original Message-----
From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Cab Vinton
Sent: Tuesday, January 12, 2010 10:08 AM
To: Koha list
Subject: [Koha] Circulation report w/ each item

We break our circulation statistics down in a number of ways & for the
moment at least the best way to get these will be to produce a circ
report listing the call number & checkout date for each item.

Can anyone provide some help with producing a report in this format?

Thank you,

Cab Vinton, Director
Sanbornton Public Library
Sanbornton, NH
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha