[Koha-bugs] [Bug 20274] New: itemtypes.plugin report: not handling item-level_itypes syspref

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20274

            Bug ID: 20274
           Summary: itemtypes.plugin report: not handling
                    item-level_itypes syspref
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: P5 - low
         Component: Reports
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: victor.grousset at biblibre.com
        QA Contact: testopia at bugs.koha-community.org

== Reproduce ==
1. Use staff:/cgi-bin/koha/reports/manager.pl?report_name=itemtypes
2. Change the syspref item-level_itypes
3. One case should give a 0 result


== Cause ==
There is a conditional but part of the SQL query was copy pasted without being
changed.


== Fix ==
"SELECT itemtype" → "SELECT biblioitems.itemtype" in these two lines

https://gitlab.com/koha-community/Koha/blob/673a40d2acc5c8c58b7f3e7e6d11c329d0587fc6/reports/itemtypes.plugin#L46

https://gitlab.com/koha-community/Koha/blob/673a40d2acc5c8c58b7f3e7e6d11c329d0587fc6/reports/itemtypes.plugin#L68

(or maybe the other ones)

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.