[Koha-bugs] [Bug 5697] Automatic linking in guided reports

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

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

--- Comment #11 from Owen Leonard <oleonard at myacpl.org> ---
(In reply to Katrin Fischer from comment #6)
> I think the feature is super nice, but there is a big issue for me as it
> will currently only work on the English column names.

I hadn't tested it with the new placeholder system, but after rebasing the
patch and looking again my tests were successful, with one glitch: If there is
a space inside the column name placeholder it won't work. So the SQL you tried:

SELECT 
i.itemnumber,
i.itemnumber as Exemplarnummber,
[[i.itemnumber| itemnumber for batch]],
CONCAT('<a
href=\"/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=',
i.biblionumber, '&itemnumber=', i.itemnumber, '#edititem', '\">', i.itemnumber,
'</a>' ) AS "itemnumber as edit link"
FROM items i

"[[i.itemnumber| itemnumber for batch]]" has a space before "itemnumber for
batch." With that space removed it works as expected. I think this must be
considered a bug in the placeholder parsing, since this query will fail to
trigger the expected batch item modification menu:

SELECT 
i.itemnumber AS ' itemnumber for batch'
FROM items i

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