Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
wrong returns using nlapiSearchRecord
Hi,
I used the following script to get the items in sales order:
var internal_id = xxxx;//Where xxxx is an internal id for a sales order contains 2 items var filters = []; filters[0] = new nlobjSearchFilter('internalid', null, 'is', internal_id); var columns = []; columns[0] = new nlobjSearchColumn('internalid','item'); var results = nlapiSearchRecord('salesorder', null, filters, columns); for (var i=0;i<results.length;i++) { var item1 = results[i].getValue('internalid', 'item'); nlapiLogExecution('DEBUG', 'item ' + i,item1); } nlapiLogExecution('DEBUG', 'results length',results.length);I get the following results:
item 0 --- nothing returned
item 1 --- first item internal id
item 2 --- second item internal id
0