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 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)