At 08:25 PM 5/1/2014 -0400, Steven Nickerson wrote:
Thank you Nick, That's close...at least it gets me my list in the pull-down but none of them return results, I think because the itype field in items contains the "code" and not the "description", right? I actually prefer the description be what shows up in the pull-down, but then how do I do the lookup in the SQL and use the corresponding code for the actual query?
Nick's suggestion works for me. Do you have items correctly defined under 'Administration', 'Basic parameters', 'Item type'? If so, have you checked that your items do in fact have itype in the record? E.G. : mysql> SELECT itype FROM items WHERE itemnumber=10000; +-------+ | itype | +-------+ | BK | +-------+ 1 row in set (0.00 sec) Best -- Paul
Steve
-----Original Message----- From: Nick Clemens [mailto:nick@quecheelibrary.org] Sent: Thursday, May 01, 2014 5:25 PM To: Koha Subject: Re: [Koha] Looking for help with a report
Hi Steve,
This works for me: SELECT itemnumber, barcode, itemcallnumber FROM items WHERE itype=<<Item type|itemtypes>>
You can find more info about the runtime paramters on the wiki too: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters
-Nick
On Thu, May 1, 2014 at 4:33 PM, Steven Nickerson <snicker1@maine.rr.com>wrote:
Is there someone who can provide the SQL for me for a report that simply lists the itemnumber, barcode, and itemcallnumber for all items of a given Item Type. I'd like the report to prompt (with a pull-down) the list of all Item Types I have so that I can select it to report on. I think this should be easy but for some reason I can't get the pull-down list to populate with anything at all.
THANKS!
Steve