[jmcadams Contributions: 0Level 1☆]

Anyone have any luck with concatentating case messages in a saved search? I am working on a saved search for cases and each MESSAGE is listed individually (creating a row for each message) and I’m not seeing a way to group them all into one cell.

I need to find a way where each case has one row and all related messages (to the case) are combined into one cell. Any suggestions?
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC Contributions: 0Level 1☆]

I don’t think that’ll be possible purely in SQL. You would need to use scripting to paste/append messages into a hidden field on the Case as they come in. Then in the search you can just output this single, massive field. It is possible though the character count will pop anything NS can handle. Could happen in theory.

[cdelacruz Contributions: 0Level 1☆]

Hello,

Try:Results tab > Columns subtab:Number | Summary Type = Group
Formula (Text) | Summary Type = Maximum | Formula: ns_concat({message})

Note: Would not work if a case contains many messages.

[Olivier Gagnon NC Contributions: 0Level 1☆]

Rreeeeaally

Can you expand a little on what this ns_concat() does exactly?

[cdelacruz Contributions: 0Level 1☆]

It works the same way as the wm_concat function in Oracle

[al3xicon Contributions: 0Level 1☆]

See also: http://blog.prolecto.com/2014/05/16/…-saved-search/

[rnedelkow Contributions: 0Level 1☆]

The ns_concat() method might reach the character limit of the text field as Olivier Gagnon NC said, if you are concatenating a lot of messages.

[Author]

Posts