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?
Steve -----Original Message----- From: Nick Clemens [mailto:[email protected]] 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 <[email protected]>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 > > _______________________________________________ > Koha mailing list http://koha-community.org [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Nick Clemens Quechee & Wilder Libraries [email protected] http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
