[Koha] Looking for help with a report

[Paul A]

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 at 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 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