Matt Bernstein
10/21/2021, 5:14 PMlib.query = (options) => {
return lib.parseSqlPagedResults((query.runSuiteQLPaged({
query: options.sql,
pageSize: options.pageSize || 5000,
})));
};
lib.parseSqlPagedResults = (response) => {
let results = [];
response.pageRanges.forEach((page, pageIndex) => {
response.fetch(pageIndex).data.results.forEach((rowObj) => {
results.push(rowObj.asMap());
});
});
return results;
};
Cory Weiner
10/21/2021, 7:54 PMCory Weiner
10/21/2021, 8:00 PMquery.runSuiteQL({query: querystring).asMappedResults()
Matt Bernstein
10/22/2021, 2:55 PM