Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Last message in case saved search
I'm creating a saved search which outputs cases. On the output columns, I'm including Message Text ({message}), so am getting multiple rows when a case comprises of multiple messages.
I want to remove the multiple rows and am using a number of CASE WHEN clauses on the {status}, {messagedate},{lastmessagedate},etc criteria, but am struggling to get the right combination of attributes. I don't think I can use group on the output, as I'm also using CASE WHEN and SUM logic on other fields.
Is there a simpler option to remove the unwanted rows, ie. a criteria to only match last message, or an alternative attribute to use on the results? I've tried checking the Netsuite records browser for supportcase without success.