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;
};
stalbert
10/21/2021, 5:26 PMMatt Bernstein
10/21/2021, 5:27 PMSim Greenbaum
10/21/2021, 5:28 PMMatt Bernstein
10/21/2021, 5:29 PMSim Greenbaum
10/21/2021, 5:30 PMmichoel
10/21/2021, 8:05 PMSim Greenbaum
10/21/2021, 8:06 PMZach Rumancik
10/22/2021, 2:47 PMSim Greenbaum
10/22/2021, 2:50 PMMatt Bernstein
10/22/2021, 2:53 PMSim Greenbaum
10/22/2021, 2:54 PMZach Rumancik
10/22/2021, 2:55 PMMatt Bernstein
10/22/2021, 2:56 PMZach Rumancik
10/22/2021, 2:58 PMZach Rumancik
10/22/2021, 2:59 PMMatt Bernstein
10/22/2021, 3:04 PMZach Rumancik
10/22/2021, 3:10 PMMatt Bernstein
10/22/2021, 3:17 PMZach Rumancik
10/22/2021, 3:18 PM