[Koha] Looking for help with a report

[Nick Clemens]

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 at 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
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Nick Clemens
Quechee & Wilder Libraries
Nick at quecheelibrary.org
http://www.QuecheeLibrary.org
Q (802) 295-1232 W (802) 295-6341