Many SQL reports use CONCAT to build hyperlinks into reports output. The current version of the template has an html filter on all report output.
Created attachment 80366 [details] [review] Bug 21541: Use raw filter for report results To test: 1 - Create new report SELECT CONCAT('<a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=',borrowernumber,'">',"",firstname,"",surname,'</a>') AS people FROM borrowers 2 - Run this report 3 - Note the results contain raw text, they are not hyperlinks 4 - Apply patch 5 - Reload the results 6 - They should now be links
Created attachment 80430 [details] [review] Bug 21541: Use raw filter for report results To test: 1 - Create new report SELECT CONCAT('<a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=',borrowernumber,'">',"",firstname,"",surname,'</a>') AS people FROM borrowers 2 - Run this report 3 - Note the results contain raw text, they are not hyperlinks 4 - Apply patch 5 - Reload the results 6 - They should now be links Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
One line patch - obviously needed!
Pushed for 18.11. Thanks all!
Caused by 13618 not in 18.05.x