[Koha-bugs] [Bug 5282] New: itemtype limit not applying
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Oct 6 17:09:31 CEST 2010
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 at gmail.com
ReportedBy: nengard at gmail.com
QAContact: koha-bugs at 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.
More information about the Koha-bugs
mailing list