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.
SuiteScript Item Search
I am new to scripting in NetSuite so please forgive my ignorance, but I am trying to do a scripted search that will return a list of all members in an item kit. To perform the item search in the UI I use the kit name as the criterion and return custom item fields found under the Member List. So it seems like the scripted equivalent would be
var searchName = //string containing name of kit item var filters = new Array(); filters[0] = new nlobjSearchFilter( 'itemid', null, 'haskeywords', searchName); var columns = new Array(); columns[0] = new nlobjSearchColumn('custitem_1', 'memberitem'); columns[1] = new nlobjSearchColumn('custitem_1', 'memberitem'); var searchresults = nlapiSearchRecord( 'item', null, filters, columns ); 0