Bug 5282

Summary: Guided reports itemtype limit not applying
Product: Koha Reporter: Nicole C. Engard <nengard>
Component: ReportsAssignee: Galen Charlton <gmcharlt>
Status: CLOSED FIXED QA Contact: Bugs List <koha-bugs>
Severity: major    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
URL: cgi-bin/koha/reports/guided_reports.pl
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Nicole C. Engard 2010-10-06 15:09:30 UTC
I followed these steps:

1. Build New
2. Choose Cataloging
3. Choose Tabular
4. Choose 'barcode', 'call number', 'title', 'author'
5. Choose to limit on item type 'nonfic' and location 'adult'

My final report looks like this:

SELECT items.barcode,items.itemcallnumber,biblio.author,biblio.title FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype=<<itype|itemtype>> AND items.location='ADULT' ORDER BY items.itemcallnumber asc 

Everything is okay except for the item type which is not showing the actual item type I chose.
Comment 1 Owen Leonard 2013-01-29 17:49:51 UTC
This seems to be working in current master.