[Koha-bugs] [Bug 24305] 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

--- Comment #8 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
Figured out how you should use the square brackets in a SQL query in Reporting.
Well documented?
You can do:
SELECT [[items.biblionumber|bieb]]
This becomes SELECT items.biblionumber AS bieb
Not sure why we need it if using "AS" is just as easy but anyway.
Adding a few comment lines in the code with a follow-up.

Using this construct does not work with the == 'biblionumber' test. Adding one
extra line in get_prepped_report for that as well. This is consistent with the
headers filled by $sth->{NAME}.

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