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

--- Comment #9 from Ray Delahunty <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to