Bug 5282 - Guided reports itemtype limit not applying
Summary: Guided reports itemtype limit not applying
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low major (vote)
Assignee: Galen Charlton
QA Contact: Bugs List
URL: cgi-bin/koha/reports/guided_reports.pl
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-06 15:09 UTC by Nicole C. Engard
Modified: 2013-12-05 20:04 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.