Hi, I'm new to SuiteQL so this may be a very basic...
# suiteqla
Ava
06/18/2021, 2:27 PMHi, I'm new to SuiteQL so this may be a very basic question! Is it possible to get the sql query that a given report in NetSuite uses? I would like to customize the query based off of the report instead of starting from scratch.
s
Sandii
06/18/2021, 2:37 PMHighly doubt it
a
Ava
06/18/2021, 2:44 PMOh well, figured at least I'll try!
m
michoel
06/19/2021, 9:05 AMYou can from an analytics workbook
a
Ava
06/21/2021, 1:47 PMThank you, will check it out.
Ava
06/21/2021, 3:18 PM@michoel I'm not finding that option there, can you please point out how I can find it?
m
michoel
06/22/2021, 12:11 AM Copy code
require(['N/query'], function(query) {
const queryObj = query.load({
id: 'custworkbookXXXX'
});
console.log(queryObj.toSuiteQL().query);
});a
Ava
06/22/2021, 1:38 PMThank you so much!