Hi
I am trying to write a script to delete the results of a saved search but its only deleting 500 records and then fails.
Please help.
Here's the script:
"
function executeSavedSearch()
{
var results = nlapiSearchRecord('itemfulfillment', 535, null, null);
var maxrec = 300;
var requeue = false;
var context = nlapiGetContext();
var len = results.length;
if(results == null )
return true;
// If search result length > 300 we want to requeue.
if( results.length >= maxrec)
requeue = true;
if ( len < maxrec ) maxrec = len;
nlapiLogExecution('DEBUG', '-- Search Length= --', len);
// Now go thru each result set of the search and process
for ( var i = 0; results != null && i < len; i++ )
{
var result = results[ i ];
nlapiDeleteRecord(results[i].getRecordType(), results[i].getId());
if ( context.getRemainingUsage() <= 0 && (i+1) < len )
{
var status = nlapiScheduleScript(context.getScriptId(), context.getDeploymentId())
if ( status == 'QUEUED' )
break;
}
}
}
"