Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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.