[cjparker84 Contributions: 0Level 1☆]

I am trying to create a NetSuite Case Search that grabs the “latest author” of a message to our customers. I know I can do this by using the associated messages record and setting the summary type to “Maximum” with an order by “date” for the message… but then that requires every other item in my search to be grouped and it just adds noise to the search.

Is there a formula I can run to grab the latest author name? Alternatively, we could make a field that populates with “latest author” but that seems unnecessary as the data is there already.

I am just curious if there’s a better way to do this. Seems simple enough to just reference back to the latest message entry and grab the author versus grouping them… look forward to the input. Thanks!
This is a cached copy. Click here to see the original post.

[robert.paulson Contributions: 0Level 1☆]

Hi,

You can get the desired results by using a formula text under the criteria of your saved search.

Field: Formula (Text)

Formula: CASE WHEN {lastmessagedate} = {messages.messagedate} THEN ‘lastmessage’ ELSE ‘NotRecent’ END

Then you would include under your Formula (Text) field “contains” lastmessage.

This will show the last message from your case.

Hope this helps.

– Robert

[cjparker84 Contributions: 0Level 1☆]

Originally posted by robert.paulson

View Post

Hi,

You can get the desired results by using a formula text under the criteria of your saved search.

Field: Formula (Text)

Formula: CASE WHEN {lastmessagedate} = {messages.messagedate} THEN ‘lastmessage’ ELSE ‘NotRecent’ END

Then you would include under your Formula (Text) field “contains” lastmessage.

This will show the last message from your case.

Hope this helps.

– Robert

Thank you! This did the trick.

[Author]

Posts