[Koha-bugs] [Bug 24305] New: Batch Item modification via item number in reports does not work with CONCAT in report

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

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

            Bug ID: 24305
           Summary: Batch Item modification via item number in reports
                    does not work with CONCAT in report
 Change sponsored?: ---
           Product: Koha
           Version: 19.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Cataloging
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: bwsdonna at gmail.com
        QA Contact: testopia at bugs.koha-community.org
                CC: m.de.rooy at rijksmuseum.nl

If you have a report with a CONCAT statement in it, and use that report to pass
the item numbers to the batch item modification, the batch modification does
not work.  Title list does not show, just the edit item screen, and if you
proceed, nothing is modified.

To create, use a report such as:
SELECT
items.biblionumber,items.itemcallnumber,items.itype,biblio.author,biblio.title,
biblio.copyrightdate, items.barcode, items.location,CONCAT('<a
href=\"/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=',
biblionumber, '&itemnumber=', itemnumber, '#edititem', '\">', itemnumber,
'</a>' ) AS itemnumber
FROM biblio 
JOIN items USING (biblionumber) 
WHERE (items.location IS NULL OR items.location = '')
ORDER by items.itemcallnumber ASC

and see that the batch modification is blank.  Remove the concat statement, and
the batch item modification works as expected.

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