[Koha-bugs] [Bug 27443] Add an item loop mechanism to patron_emailer.pl cron

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27443 --- Comment #9 from Ray Delahunty <r.delahunty@arts.ac.uk> --- While we wait for the patron emailer to have something like an <item></item> feature addded, so titles on a loan list (for example) will appear on separate lines, we are using a SEPARATOR with a GROUP CONCAT to improve the the horrid word-wrapped list in our leavers emails. We feed the list to a notice using the loans field: (SELECT GROUP_CONCAT( ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code>="a"]') SEPARATOR '<br/>') FROM [...] AS 'loans' Works OK. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.