Reporting various Incident Thread Types in one cell
Can anyone help with the expression for the column that would output multiple thread entry types in one cell?
I. e. I need to have a cell that contains all the text from all threads in the incident.
if I simply make a column with threads.note I only get the text of the initial customer query but not the auto-response, staff responses and private notes.
When I do to_char(threads.note) I get all entries but on a separate line.
The business case here is to enable agents to quickly view the incident through the "More" link in the report rather than having to open and close the incident in a separate tab.