How to Add Filter and Use Columns to get result from Saved search in Suite Script 2.0
Hi All,
Many people are wondering "how to add filter in a saved search while loading" so I am adding small code here.
Saved Search you are trying to load in script may already have few filters, so you have to push your new filter/s into the object you get from loading of search. Code will look like below:
var mySearch = search.load({
id: 'customsearch_mydemo_saved_search'
});
var myFilter = search.createFilter({
name: 'isinactive',
operator: search.Operator.IS,
values: 'F'
});
mySearch.filters.push(myFilter);
How to get Value based on Column?
If you are using saved search and requirement is to get all columns in script , please use below code:
if(mySearch && (mySearch != null) && (mySearch != ''))
{
var resultSet = mySearch.run()
var range = resultSet.getRange({
start: 0,
end: 1000
});
for(var j=0; j < range.length; j++)
{
var mResult = range[j];
var column0Value= mResult.getValue(resultSet.columns[0]);
var column1Value= mResult.getValue(resultSet.columns[1]);
//======= and so on.
}
}
Thanks
Netsuite Guru
Download Netsuite Guru Android App
Follow Me on Linkedin
Our FB Page
Many people are wondering "how to add filter in a saved search while loading" so I am adding small code here.
Saved Search you are trying to load in script may already have few filters, so you have to push your new filter/s into the object you get from loading of search. Code will look like below:
var mySearch = search.load({
id: 'customsearch_mydemo_saved_search'
});
var myFilter = search.createFilter({
name: 'isinactive',
operator: search.Operator.IS,
values: 'F'
});
mySearch.filters.push(myFilter);
How to get Value based on Column?
If you are using saved search and requirement is to get all columns in script , please use below code:
if(mySearch && (mySearch != null) && (mySearch != ''))
{
var resultSet = mySearch.run()
var range = resultSet.getRange({
start: 0,
end: 1000
});
for(var j=0; j < range.length; j++)
{
var mResult = range[j];
var column0Value= mResult.getValue(resultSet.columns[0]);
var column1Value= mResult.getValue(resultSet.columns[1]);
//======= and so on.
}
}
Thanks
Netsuite Guru
Download Netsuite Guru Android App
Follow Me on Linkedin
Our FB Page
Comments
Post a Comment
Thanks for you message, please join us on Facebook and Linkedin