SEPARATOR '\n' not working in K1000 reporting. bug?
Below is mySQL for a report that simply shows comments for all tickets. I have bolded the part that doesn't seem to work. I have searched through articles here and found a couple that indicate this is a bug. Is that true and is it to be addressed in the future? Is there no alternative to making the comments break lines in the HTML report?
SELECT GROUP_CONCAT(DISTINCT HD_TICKET_CHANGE.COMMENT SEPARATOR '\n') AS HD_TICKET_CHANGE_COMMENT_GROUPED FROM HD_TICKET LEFT JOIN HD_TICKET_CHANGE ON (HD_TICKET_CHANGE.HD_TICKET_ID = HD_TICKET.ID) WHERE (HD_TICKET.HD_QUEUE_ID = 1) GROUP BY HD_TICKET.ID ORDER BY HD_TICKET_CHANGE_COMMENT_GROUPED
Answers (1)
Yes, it appears to be a bug - I reported it at last year's Advisory Kouncil and sent detailed info to support and product management, so hopefully it will have been fixed in the 5.4 release.
I also mentioned it here:
A potential workaround is to use the Classic Reports module, if you have happen to have an older K1000 (mine is a K1100).
John
