zbillings
01/31/2017, 5:33 PMfunction getRecord(req)
{
var col = new Array();
var fil = new Array();
var rscnt = 1000;
var nextStartIndex = 0;
var nextEndIndex = 1000;
var results = new Array();
col[0] = new nlobjSearchColumn('customform');
fil[0] = new nlobjSearchFilter('status', null,'anyof',['SalesOrd:B', 'SalesOrd:D', 'SalesOrd:E']);
var searchresults = nlapiCreateSearch( 'salesorder', fil, col);
var searchResultSet = searchresults.runSearch();
var doublecheese = {};
while (rscnt == 1000)
{
var res = searchResultSet.getResults(nextStartIndex, nextEndIndex);
for (var i=0; res!= null && i < res.length; i++)
{
var result = {};
var itemfound = 0;
result.FormName = res[i].getText('customform');
result.FormID = res[i].getValue('customform');
for (var x = 0; x < results.length; x++)
{
if (results[x].FormID == result.FormID)
{
itemfound = 1;
break;
}
}
if (itemfound === 0)
{
results.push(result);
}
}
rscnt = res.length;
nextStartIndex = nextEndIndex;
nextEndIndex = nextEndIndex + 1000;
}
doublecheese.Forms= results;
return doublecheese;
}