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

Comments