netsuite Searches with large number of results Using ResultSet.getRange method
Example
In order to use getRange for handling the large number of results, we will have to consider the following:
- getRange has 2 parameters: start and end. Always positive, always (start < end)
- start is the inclusive index of the first result to return
- end is the exclusive index of the last result to return
- If there are fewer results available than requested, then the array will contain fewer than end - start entries. For example, if there are only 25 search results, then getRange(20, 30) will return an array of 5 search.Result objects.
- Although the above help sentence doesn't say it directly, both start and end could be outside the range of available results. In the same example - if there are only 25 search results, getRange(100, 200) will return an empty array [ ]
- Maximum 1000 rows at a time. (end - start) <= 1000
// Assume that 'N/search' module is included as 'search'
// this search will return a lot of results (not having any filters)
var s = search.create({
type: search.Type.TRANSACTION,
columns : ['entity','amount'],
filters: []
});
var resultSet = s.run();
// now take the first portion of data.
var currentRange = resultSet.getRange({
start : 0,
end : 1000
});
var i = 0; // iterator for all search results
var j = 0; // iterator for current result range 0..999
while ( j < currentRange.length ) {
// take the result row
var result = currentRange[j];
// and use it like this....
var transId = result.id;
var entityId = result.getValue('entity');
var entityName = result.getText('entity');
var amount = result.getValue('amount');
// finally:
i++; j++;
if( j==1000 ) { // check if it reaches 1000
j=0; // reset j an reload the next portion
currentRange = resultSet.getRange({
start : i,
end : i+1000
});
}
}
Lets calculate the Governance. We have 1 + count/1000 getRange calls taking 10 units each, so:
G = (1 + count/1000 ) * 10
Example: 9500 rows will take 100 units
