Owen, I am not sure what you need on the interlibrary loan report request. So, I have pulled the identifiers from everywhere they say interlibrary loan. Item type: ILL Patron category: Interlibrary loan
From the item record Koha normalized classification for: INTERLIBRARY_LOAN Shelving location: Interlibrary loan Koha full call number: Interlibrary loan Koha item type: Interlibrary loan.
On the other report, we are needing a report that lists all of the records that have either nothing or the word NULL in the subfield e of the item records. Let me know if anyone needs further clarification. 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. -----Original Message----- From: Owen Leonard [mailto:oleonard@myacpl.org] Sent: Thursday, August 13, 2009 9:49 AM To: Scott Zollars Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Need help with reports
I need help constructing the following reports in SQL. I am still not fluent in that. I need a list of interlibrary loan materials checked out to other libraries by the month and by the day for our ILL record keeping.
To answer that we'd have to know how you define ILL materials in your system.
Also I need a report that lists all cataloging records with NULL in the source of acquisition field in the item records within a specific date range.
As far as I know source of acquisition isn't stored in its own field in the database. Maybe someone can confirm? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org