[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