Tutorial by Examples

To understand the filter expressions, we should start with Filter Term. This is a simple array of strings, containing at least 3 elements: Filter (Field/Join field/Formula/Summary) Operator (search.Operator) Values (string value(or array of string values), to be used as filter parameter) //...

Simple filter expression is also an array. It contains one or more filter terms, combined with operators - 'AND', 'OR', 'NOT'. (Operators are case insensitive): [ ['mainline', 'is', 'T'], 'and', ['type','anyof',['CustInvc','CustCred']], 'and', 'not', ['amount', 'equalto', '0.00'], 'or'...

Filter expressions cannot include Filter Objects. This is very important. If you decide to form your filters with Filter Expression, you use array of string arrays. The following syntax is wrong: // WRONG!!! var f1 = search.createFilter({ name: 'mainline', operator: searc...

Here you can find the list of available search filter values for date fileds: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_N3010842.html These you can use in expressions like: ['trandate', 'notbefore', 'daysAgo17'] Here are the search operators: https://system.netsui...