Hi Guys,
Can we query SQL, to display the standard...
# suiteanalyticsn
NSN
06/26/2024, 2:08 PMHi Guys,
Can we query SQL, to display the standard list in NetSuite?
Like Case Origin field , which is a list field and if i query as "Select * from supportcase" it will give me the internal id of the original field, but i need the Text.
m
Mike Robbins
06/26/2024, 2:30 PMYou can get the text without a separate join using the
BUILTIN.DF Copy code
select BUILTIN.DF(origin), * from supportcasethankyou 1
n
NSN
06/26/2024, 2:34 PMoh , thats great !!! Thank you so much Mike. You saved my day
NSN
06/26/2024, 3:03 PMis there a way to display all the available tables. ?
Like select * from OA_TABLES
m
Mike Robbins
06/26/2024, 4:02 PMI don't think so. Tim D wrote a nice article about how he uses the Record Browser API to get information about the tables available.
n
NSN
06/26/2024, 4:15 PMthanks
m
Marvin
06/26/2024, 5:34 PMYou can also just build your query in the Analytics UI and then export as SQL and that's where I get all the ids from too. Schema browser is good, but I haven't used it in so long since it's easy to get the information I need within Analytics dataset queries.
Marvin
06/26/2024, 5:39 PMAnother hack that I use to quickly test is to load "N/query" into the browser console and built the query using query.create. Then after I have a working version I will Query.toSuiteQL() to turn it into SQL. This helps me with the syntax for when I want to return not just raw context.
23 Views