https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27361 Bug ID: 27361 Summary: Guided reports in the catalog module duplicates itype Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: lucas@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org If you select the Catalog module in step 1 of a guided report you will see 'Koha itemtype' appear twice in step 4. To recreate: -Build a guided report -In step 1 select 'Catalog' as the module -In step 3 add at least one column -In step 4 notice that 'Koha itemtype' displays twice no matter what you've selected in step 3 -Check both the 'Koha itemtype' and continue to build your report. -On the confirm your report page notice the SQL looks like this: SELECT items.itemnumber FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.itype='BK' No matter what you select as the 2nd itype you will get a duplicate of what you selected in the first: WHERE items.itype='BK' AND items.itype='BK' -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.