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:[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
