N/query Module
query.Operator
Enum Description: Holds the string values for operators supported in SuiteScript Analytic APIs. SuiteScript Analytic APIs help you work with analytical data in NetSuite using SuiteScript. For more information, see SuiteScript Analytic APIs. This enum is used to specify the operator argument to Query.createCondition(options) and Component.createCondition(options). This enum is also used to specify the operator argument to methods in the N/dataset and N/workbook modules, such as dataset.createCondition(options) and workbook.createTableFilter(options). For more information, see Workbook API (Beta). Values for this enum are listed in the Values section. The following columns provide information about each operator: Value — Use these values to specify operators in most queries (for example, query.Operator.BEFORE). To use these values, you must include the N/query module in your script. Mapped String Value — Use these values as strings that represent the corresponding operators (for example, 'BEFORE'). To use these values, you do not need to include the N/query module in your script. Use For — Use this column to determine the value types that each operator supports. For example, the query.Operator.AFTER operator is designed to be used with date/time values, and you cannot use this operator with string or boolean values. Some operators are similar but are designed to be used with different value types (such as query.Operator.IS for boolean values and query.Operator.EQUAL for numeric values). For multi-select fields, you can use the query.Operator.INCLUDE_* and query.Operator.EXCLUDE_* values to specify a set of exact field values. For example, to obtain script deployment records that apply to all execution contexts except the WEBAPP and WEBSTORE contexts, you can use the query.Operator.EXCLUDE_ALL operator. You cannot use the query.Operator.ANY_OF_NOT operator to obtain these records, because this operator uses an implicit OR operator between all specified values. The query.Operator.EXCLUDE_ALL operator uses an implicit AND operator between all specified values, which lets you create more complex conditions. JavaScript does not include an enumeration type. The SuiteScript 2.0 documentation uses the term enumeration (or enum) to describe a plain JavaScript object with a flat, map-like structure. In this object, each key points to a read-only string value.
Module: N/query Module
Sibling Module Members: N/query Module Members
Since: 2018.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=query.Operator

// Code Example 1

// Add additional code

//...

var myCustomerQuery = query.create({

    type: query.Type.CUSTOMER

});



var mySalesRepJoin = myCustomerQuery.autoJoin({

    fieldId: 'salesrep'

});



var firstCondition = myCustomerQuery.createCondition({

    fieldId: 'id',

    operator: query.Operator.EQUAL,

    values: 107

});

var secondCondition = myCustomerQuery.createCondition({

    fieldId: 'id',

    operator: query.Operator.EQUAL,

    values: 2647

});

var thirdCondition = mySalesRepJoin.createCondition({

    fieldId: 'email',

    operator: query.Operator.START_WITH_NOT,

    values: 'foo'

});



myCustomerQuery.condition = myCustomerQuery.and(

    thirdCondition, myCustomerQuery.not(

        myCustomerQuery.or(firstCondition, secondCondition)

    )

);



var resultSet = myCustomerQuery.run();

//...

// Add additional code



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