Query.condition

Note:

The content in this help topic pertains to SuiteScript 2.0.

Property Description

The simple or nested condition (a query.Condition object) that narrows the query results.

The query.Condition object acts in the same capacity as the search.Filter object in the N/search Module. The primary difference is that query.Condition objects can contain other query.Condition objects.

To create conditions:

Use Query.createCondition(options) to create conditions for the initial query definition created with query.create(options).
Use Component.createCondition(options) to create conditions for the join relationships created with Query.autoJoin(options) and Component.autoJoin(options).
If you have multiple conditions, use them to create a new nested condition with the methods Query.and(conditions), Query.or(conditions), and Query.not(condition).
Assign your simple or nested condition to Query.condition. For an example, see Syntax.

Type

query.Condition

Module

N/query Module

Parent Object

query.Query

Sibling Object Members

Query Object Members

Since

2018.1

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/query Module Script Samples.

            // Add additional code
...
var myCustomerQuery = query.create({ type: query.Type.CUSTOMER
}); var mySalesRepJoin = myCustomerQuery.autoJoin({ fieldId: 'salesrep'
}); var myFirstCondition = myCustomerQuery.createCondition({ fieldId: 'id', operator: query.Operator.EQUAL, values: 107
}); var mySecondCondition = myCustomerQuery.createCondition({ fieldId: 'id', operator: query.Operator.EQUAL, values: 2647
}); var myThirdCondition = myCustomerQuery.createCondition({ fieldId: 'email', operator: query.Operator.START_WITH_NOT, values: 'foo'
}); myCustomerQuery.condition = myCustomerQuery.and( myThirdCondition, myCustomerQuery.not( myCustomerQuery.or(myFirstCondition, mySecondCondition) )
);
...
// Add additional code

Syntax

Related Topics