Modules
Objects/Functions
SuiteScript 2.0
// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=ResultSet.iterator() for more information.
N/query Module
ResultSet.iterator()
Method Description:
Standard SuiteScript 2.0 object for iterating through results
Returns:
Iterator object
Supported Script Types:
Client and server scripts
For more information, see SuiteScript 2.0 Script Types.
Governance:
None
Module:
N/query Module
Parent Object:
query.ResultSet
Sibling Object Members:
ResultSet Object Members
Since:
2018.1
Search NetSuite -
https://system.netsuite.com/app/help/helpcenter.nl?search=ResultSet.iterator()
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 queryResultSet = myCustomerQuery.run();
// Fetch results using an iterator
var iterator = queryResultSet.iterator();
iterator.each(function(result) {
var currentResult = result.value;
log.debug(currentResult);
return true;
});
// Alternatively, fetch results using a loop
var queryResults = queryResultSet.results;
for (var i = 0; i < queryResults.length; i++) {
var currentResult = queryResults[i];
log.debug(currentResult);
}
//...
// Add additional code
//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1510790932.html