Query.and(conditions)

Note:

The content in this help topic pertains to SuiteScript 2.0.

Method Description	Creates a new condition (a query.Condition object) that corresponds to a logical conjunction (AND) of the arguments passed to the method. The arguments must be one or more query.Condition objects. A condition 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 parent condition with the methods Query.and(), Query.or(conditions), and Query.not(condition). Assign your parent condition to Query.condition. For an example, see Syntax.
Returns	query.Condition
Supported Script Types	Client and server scripts For more information, see SuiteScript 2.x Script Types.
Governance	None
Module	N/query Module
Parent Object	query.Query
Sibling Object Members	Query Object Members
Since	2018.1

Parameters

Parameter	Type	Required / Optional	Description
condition 1 — n	query.Condition[]	required	One or more condition objects. There is no limit on the number of conditions you can specify.

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 myLocationJoin = mySalesRepJoin.autoJoin({ fieldId: 'location'
}); 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 

          

Related Topics

query.Query

N/query Module

SuiteScript 2.x Modules

SuiteScript 2.x

General Notices