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

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

2

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:

http://www.itninja.com/blog/view/workaround-for-line-break-character-bug-in-reports-generated-on-inventory-custom-fields

A potential workaround is to use the Classic Reports module, if you have happen to have an older K1000 (mine is a K1100).

John

Answered 11/08/2012 by: jverbosk
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity