Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

query.Page

// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=query.Page for more information.

N/query Module
query.Page
Object Description: One page of the paged query results.
Supported Script Types: Client and server scripts For more information, see SuiteScript 2.0 Script Types.
Module: N/query Module
Methods and Properties: Page Object Members
Since: 2018.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=query.Page

Example:

// Code Example 1
// Add additional code
//...
var myCustomerQuery = query.create({
type: query.Type.CUSTOMER
});

myCustomerQuery.columns = [
myCustomerQuery.createColumn({
fieldId: 'entityid'
}),
myCustomerQuery.createColumn({
fieldId: 'firstname'
}),
myCustomerQuery.createColumn({
fieldId: 'email'
})
];

var myPagedResults = myCustomerQuery.runPaged({
pageSize: 10
});

// Fetch results using an iterator
var iterator = myPagedResults.iterator();
iterator.each(function(resultPage) {
var currentPage = resultPage.value;
log.debug(currentPage.pageRange.size);
return true;
});

// Alternatively, fetch results using a loop
for (var i = 0; i < myPagedResults.pageRanges.length; i++) {
var currentPage = myPagedResults.fetch(i);
log.debug(currentPage.pageRange.size);
}
//...
// Add additional code

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1510779287.html