http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5282 Summary: itemtype limit not applying Change sponsored?: --- Product: Koha Version: HEAD Platform: All URL: cgi-bin/koha/reports/guided_reports.pl OS/Version: All Status: NEW Severity: major Priority: P5 Component: Reports AssignedTo: gmcharlt@gmail.com ReportedBy: nengard@gmail.com QAContact: koha-bugs@lists.koha-community.org Estimated Hours: 0.0 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.