Written by: Ely Beltran
In a NetSuite Saved search, the number of results would be based on the criteria. There are some instances
where only a particular number of results are needed. Here are example use cases where showing a certain limit of results is ideal:
The saved search has 100,000 results, but the user would only like a sample of 100. Running this search and displaying the results would take some time. Adding a criterion to limit the number of results is one way of limiting the results, but the user would still need to determine the proper criteria.
The large number of results from the saved search would be read by a script, but processing a large dataset would clog the scripting queue. Ideally, the developer would like to process only 1000 records with each run.
This tutorial will demonstrate how to set a certain limit on the results in the saved search.
Saved Search ROWNUM Criteria
Edit any existing Saved Search
Add a new Criteria.
Select Formula (Numeric), this will open a new window.
In the new window, add the following field values:
Save and Run the search.
The search should only show 10 results, this is due to the ROWNUM formula added to the criteria.
Etter+Ramli as the Trusted, Independent Managed Services Provider for NetSuite
Using NetSuite Managed Services could be your growing company's best strategic move. NetSuite Managed Services offers a comprehensive solution, granting companies access to a team of experienced NetSuite administrators and consultants to manage their NetSuite ERP. Typically, this service is more affordable than hiring in-house staff. When you use managed services, your systems are always up-to-date. In the world of IT, systems are consistently upgraded and patched and come with a slew of security protocols. It is a lot to handle, but your teams can handle this when implementing managed services.
The goal is to ensure your NetSuite instance supports your business’ growth.
For over 20 years, Etter+Ramli has helped several companies optimize their NetSuite software solution. With a 95% customer satisfaction rate, Etter+Ramli can provide your company with world-class support, Certified NetSuite experts, and a value-based pricing structure.
Etter+Ramli As Your Extended NetSuite Team
Etter+Ramli is an Independent Managed Success Provider for NetSuite clients. We are NOT partnered with Oracle NetSuite and do not take commissions. We bring our knowledge, expertise, and passion for success to our clients. We help clients Buy, Deploy, Grow, and Abandon NetSuite. We engage as a client-side managed service to ensure our priorities align with our clients.