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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
