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.
addField with a joined result
Hi all,
I'm trying to do something very simple, this first section grabs a list of items and other details about an existing customer.
filters[0] = new nlobjSearchFilter('custrecord_itempartinlocation',null,'is',searchResults[i].getValue('internalid')); columns[0] = new nlobjSearchColumn('displayname','custrecord_itempartmanageditem',null); columns[1] = new nlobjSearchColumn('custrecord_itempartserialnumber',null,null); columns[2] = new nlobjSearchColumn('custrecord_itempartlocationinproperty',null,null); columns[3] = new nlobjSearchColumn('custrecord_itempartactivateddate',null,null); var searchResultsItems = nlapiSearchRecord('customrecord_itemparticulars',null,filters,columns); The search results return exactly what I want, verified in the debugger. The problem happens when I try to show the result in a subList.
sublist[i].addField('displayname','text','Item Name',null); sublist[i].addField('custrecord_itempartserialnumber','text','Serial Number',null); sublist[i].addField('custrecord_itempartlocationinproperty','text','Location in Property',null); sublist[i].addField('custrecord_itempartactivateddate','date','Activated Date',null); sublist[i].setLineItemValues(searchResultsItems); 0