List Latest Message in a Transaction Search

Create a saved search on Transaction to list the most recent message as follows:

1. Navigate to Lists > Search > Saved Searches > New.
2. Click on Transaction.

3. Enter a name in the Search Title

4. Click on Results tab > Columns subtab and set the following fields:

--Number > Summary Type = Group
--Message:Date > Summary Type = Maximum

--Formula (text) > Summary Type = Maximum; Formula = max(to_char(substr({messages.message},1,4000)))keep(dense_rank last order by{messages.messagedate})

5. Click Save & Run

 

Note: Fields can be added or removed as per requirement. The search results will allow viewing the most recent message from transanction along with the message date and transaction number.