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.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Customer fields / table to SQL
I've been asked to create the SQL Statement for a save searched.
It was quite easy until I tried to link to a "custom field". Let me go in more detail.
The search is about location, so the field part is easy
select Name, City... from location
We have unique region. We created a custom fields with all the values
I'm trying to link to the custom field, which I have no idea
Any help will be greatly appreciate
0