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.
How can I use SQL formula in Global Search?
Hi All,
I found a page in Help Center which is "Tips for Effective Global Searches" under SuiteAnalytics -> Search -> Finding Records -> Global Search -> Tips for Effective Global Searches.
There is below formula on the page, however I cannot make it work in my account.
SELECT * FROM Customers WHERE City LIKE 'Minn%';
I tried below formula to list customers in Sydney region for test.
I entered this formula in Global Search text box on top of a page, then pressed enter key. However it does not lies anything. (Of course there are Customer records having City: Sydney as billing address)
Tagged:
4