Search for Items in a Custom List
The following sample creates a search for items in a custom list. It searches for the internal ID value of an abbreviation in a custom list named customlist_mylist.
Note:
This sample script uses the require function so that you can copy it into the SuiteScript Debugger and test it. You must use the define function in an entry point script (the script you attach to a script record and deploy). For more information, see SuiteScript 2.x Script Basics and SuiteScript 2.x Script Types.
/**
* @NApiVersion 2.x
*/
require(['N/search'], function(search) {
var internalId = -1;
var myCustomListSearch = search.create({
type: 'customlist_mylist',
columns: [
{ name : 'internalId' },
{ name : 'abbreviation' }
]
});
myCustomListSearch.filters = [
search.createFilter({
name: 'formulatext',
formula: '{abbreviation}',
operator: search.Operator.IS,
values: abbreviation
});
]
var resultSet = myCustomListSearch.run();
var results = resultSet.getRange({
start: 0,
end: 1
});
for(var i in results) {
// log.debug('Found custom list record', results[i]);
internalId = results[i].getValue({
name:'internalId'
});
};
});