Case Search to Show Most Recent Message Only

To show only the most recent message, perform the following steps:
  
     1. Navigate to Lists > Search > Saved Searches > New.
     2. Select Case.

     3. Provide a Search Title.

     4. In the Results tab > Columns subtab, set the following:

Field	Summary Type	Formula
Number	Group
Messages:Date	Maximum
Formula (text)	Maximum	max(to_char(substr({messages.message},1,4000)))keep(dense_rank last order by{messages.messagedate})

    

     5. Click Save and Run.

Results: