Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to show only the latest change to a saved search?
Hi,
I am trying to write a saved search that will show me the last modification date and the person modifying any saved search (using audit trail search). However, I am struggling to just show the last update as it keeps grouping the results by every user and does not show only the top row (last modification). The grouping is not working as expected as it creates multiple groups, one each for every user who modified this saved search.
Is it possible to do something similar to the below in the criteria section?
where date = select max(date)…
For example, I would only like to display the red highlighted row against this saved search, even though the same user (A) has made two modifications at the same time.