with suite analytic connect query, how can i iterate pages in the query language?

AI generated answer (using internal Slack threads):

To iterate pages in the Suite Analytics Connect query language, you can use the

runSuiteQLPaged

method which returns a

PagedData

object. This object has an

iterator

method that you can use to loop through the pages. Here is a simplified example of how you can use it:

javascript
var myPagedData = query.runSuiteQLPaged({
    query: myQuery,
    pageSize: 1000
});

var myIterator = myPagedData.iterator();

while (myIterator.hasNext()) {
    var resultPage = myIterator.next();
    var currentPage = resultPage.value;
    var currentPageData = currentPage.data;
    // process currentPageData
}

In this example,

myQuery

is your SuiteQL query, and

pageSize

is the number of rows you want to fetch per page. The

iterator

method returns an iterator that you can use to loop through the pages. The

hasNext

method checks if there are more pages, and the

next

method gets the next page. The

value

property of the page contains the actual data, which you can process as needed. Please note that the

asMappedResults

method cannot be used with

runSuiteQLPaged

. Instead, you can access the data directly from the

value

property of the page. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******