Bug 27824: Trim column headers
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 5 Jul 2023 13:44:50 +0000 (15:44 +0200)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 18 Jul 2023 11:24:01 +0000 (12:24 +0100)
commit741f711d5ebad5da7e09896b66c25876a7971b62
tree618be44cb3894e489690a54174de537651c5d28c
parent5f6f595af593c0f4dcc8a6f55177cb2a11e56096
Bug 27824: Trim column headers

To support additional spaces.

Using the system for defining a column name placeholder (Bug 23390), if
there is a space inside the column name placeholder it won't work. The
SQL example in Bug 5697:

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.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 2c73648f77e530fdd50885bd0e72343d0d4c5c4e)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Koha/Report.pm