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!