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