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.
How to do a search on item record?
Hi,
I need to get the internal id of an item whose itemname is a given text.Is there a way to do this.I did a search for this but I get an error.
Error: SSS_INVALID_SRCH_FILTER An nlobjSearchFilter contains invalid search criteria: itemid.
The code is shown below.Is there anything I am missing in the code?
var cols = new Array();
cols[0] = new nlobjSearchColumn('internalid');
cols[1] = new nlobjSearchColumn('itemid');
var filtersArr = new Array();
filtersArr[0] = new nlobjSearchFilter('itemid', null, 'is', revisionTypeText , null);
var searchResultArr = nlapiSearchRecord('item', null, filtersArr, cols);
Thanks,
Iby
0