[Koha] Monthly ILL report

[Scott Zollars]

Thanks to whoever devised the SQL for my report request. I need to tweak
it a little though. This is the current SQL

 

Scotty Zollars

Circulation

List interlibrary loan materials check out to other libraries, by month

SELECT  monthname(datesent) month,COUNT(*) 

FROM branchtransfers where frombranch="MMM" and
YEAR(datesent)=YEAR(NOW())-1 

GROUP BY month ORDER by month(datesent)

 

 

We are just one branch . We treat our ILL customers like community
patrons and that is our patron type for them. We put ILL as the surname
for all of our ILL patrons, for example, Surname: ILL, First Name: Erie
Public Library. How should I adapt this to take this into account and to
also show the titles.

 

Sorry to be a pain,

 

Scotty Zollars

Director of Library Services

Labette Community College

200 S. 14th

Parsons, KS  67357

620-820-1168

620-421-1469 FAX

 

Four things you can't recover: The stone after the throw,  the word
after it's said,  the occasion after it's missed and the time after it's
gone.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090818/fccaaf0a/attachment-0001.htm