Is there any way to do SuiteQL in SuiteScript yet?
# suitescript
c
Is there any way to do SuiteQL in SuiteScript yet?
b
2020.1 new feature
should be safe and working by 2020.2
c
I thought I read that in the release guide but then thought maybe I'd got confused
I wouldn't call SuiteScript or SuiteTalk safe yet :)
m
SuiteQL in the N/query Module In SuiteScript, you can create and run SuiteQL queries using the N/query module. Queries created using SuiteQL can be more powerful and flexible than queries created using other APIs in the N/query module. SuiteQL queries can also provide the best query performance for many use cases. You can create your own SuiteQL query strings, which lets you design and run complex SQL queries that cannot be created otherwise. For examples of SuiteQL queries you can create, see Examples of Using SuiteQL in the N/query Module. helpcenter.nl?fid=section_157960623712.html
n
Just for knowledge, what is the use case for SuiteQL when we have N/search module? Does it support 2nd level join?
b
SuiteQL is a query language based on the SQL-92 revision of the SQL database query language. It provides advanced query capabilities you can use to access your NetSuite records and data. For more information, see SuiteQL.
s
@NickSuite yes it supports up to 5 level of joins
n
Thanks @Sandii and @battk
c
Thanks all. Does anyone know where to see what records and fields are available for querying and whether these will be more than are available via Suitescript-ed searches? Actually, I just read https://3640472.app.netsuite.com/app/help/helpcenter.nl?fid=section_1543418356.html and it implies that I can find out by browsing the records and fields in Analytics