Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
What are your saved search query optimization tips?
I have a saved search that occasionally times out. Not good. What are your best tips for how to optimize performance on a saved search query?
Here is one from the NetSuite Basics Guide:
Avoid using "contains." Use "starts with" or "keywords" instead when it's possible.
Regarding searches that time out, BrettKnights says:
[LIST]doing an "any of" status query tends to return results quickly but "none of" status queries tend to cause this issue.[/LIST]
[LIST]adding an "on or after" date query tends to clean up this issue.[/LIST]
You can read his post here.
What tips or guidelines would you add to these?
0