Modules

filter

 

Objects/Functions

module (N/search)

SuiteScript 2.0

Main Examples

N/search Module
Member Type: Name
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=N/search Module

// Code Example 1
/**
* @NApiVersion 2.x
*/

require(['N/search'], function(search) {
var mySearch = search.create({
type: search.Type.CUSTOMER,
columns: ['entityid', 'firstname', 'lastname', 'salesrep'],
filters: ['entityid', 'contains', 'Adam']
});

var myResultSet = mySearch.run();

var resultRange = myResultSet.getRange({
start: 0,
end: 50
});

for (var i = 0; i < resultRange.length; i++) {
log.debug(resultRange[i]);
}
});

// Code Example 2
/**
* @NApiVersion 2.x
*/

require(['N/search'], function(search) {
function createSearch() {
var mySalesOrderSearch = search.create({
type: search.Type.SALES_ORDER,
title: 'My SalesOrder Search',
id: 'customsearch_my_so_search',
columns: ['entity', 'subsidiary', 'name', 'currency'],
filters: [
['mainline', 'is', 'T'],
'and', ['subsidiary.name', 'contains', 'CAD']
]
});

mySalesOrderSearch.save();
}

createSearch();
});

// Code Example 3
/**
* @NApiVersion 2.x
*/

require(['N/search'], function(search) {
function loadAndRunSearch() {
var mySearch = search.load({
id: 'customsearch_my_so_search'
});

mySearch.run().each(function(result) {
var entity = result.getValue({
name: 'entity'
});
var subsidiary = result.getValue({
name: 'subsidiary'
});

return true;
});
}

loadAndRunSearch();
});

// Code Example 4
/**
* @NApiVersion 2.x
*/

require(['N/search'], function(search) {
function runSearchAndFetchResult() {
var mySearch = search.load({
id: 'customsearch_my_so_search'
});

var searchResult = mySearch.run().getRange({
start: 0,
end: 100
});
for (var i = 0; i < searchResult.length; i++) {
var entity = searchResult[i].getValue({
name: 'entity'
});
var subsidiary = searchResult[i].getValue({
name: 'subsidiary'
});
}
}

runSearchAndFetchResult();
});

// Code Example 5
/**
* @NApiVersion 2.x
*/

require(['N/search'], function(search) {
function loadAndRunSearch() {
var mySearch = search.load({
id: 'customsearch_my_so_search'
});

var myPagedData = mySearch.runPaged();
myPagedData.pageRanges.forEach(function(pageRange){
var myPage = myPagedData.fetch({index: pageRange.index});
myPage.data.forEach(function(result){
var entity = result.getValue({
name: 'entity'
});
var subsidiary = result.getValue({
name: 'subsidiary'
});
});
});
}

loadAndRunSearch();
});

// Code Example 6
/**
* @NApiVersion 2.x
*/

require(['N/search'], function(search) {
var myCustomRecordSearch = search.create({
type: search.Type.CUSTOM_RECORD + '6';
title: 'My Search Title',
columns: ['custrecord1']
}).run().each(function(result) {
// Process each result
return true;
});
});

// Code Example 7
/**
* @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'
});
};
});

// Code Example 8
/**
* @NApiVersion 2.x
*/

require(['N/search'], function(search) {
function deleteSearch() {
search.delete({
id: 'customsearch_my_so_search'
});
}

deleteSearch();
});

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4345764122.html