LOADING A SEARCH IN 2.0 SCRIPT AND OVERCOMING 1000 ROWS LIMIT
Category : SuiteScript 2.0
var mysearch = search.load({
id: ‘8888’ // enter the existing search id (name or internal id)
});
var fil = search.createFilter({
name: ‘inactive’,
operator: ‘is’,
values: false
});
mysearch.filters.push(fil);
var customersearchResult = mysearch.run().getRange(0, 1000);
if(customersearchResult!=null&&customersearchResult!=”&&customersearchResult!=’ ‘)
{
var completeResultSet = customersearchResult; //copy the result
var start = 1000;
var last = 2000;
while(customersearchResult.length == 1000)//if there are more than 1000 records
{
customersearchResult = mysearch.run().getRange(start_range, last_range);
completeResultSet = completeResultSet.concat(customersearchResult);
start = parseFloat(start)+1000;
last = parseFloat(last)+1000;
}
customersearchResult = completeResultSet;
log.debug({
title: ‘customer len’,
details: customersearchResult.length,
});
}
Feel free to reach out TheSmilingCoders for proper netsuite implementation, netsuite consultation , netsuite customization, netsuite Support,netsuite Trainingcontact us at:
Email : [email protected]
Linkedin : https://www.linkedin.com/company/netsuite-academy/