Expose the Seconds Timestamp from the Transaction System Notes of Transaction Saved Search

Scenario

User wants to create a Transaction Saved Search to expose the seconds timestamp from the transaction’s System Notes.

Solution

To be able to expose the timestamp in seconds of the Transaction System Notes of Transaction Saved Search, user needs to add the following in the Transaction Saved Search:

1.  On the Results tab 

• Filter: Select Formula (Text) 
• Formula: Add to_char({systemnotes.date},’HH:MI:SS’)

2.Click Save & Run