Logical Operators
Logical operators can be used in the field expression of the WHERE clause in a SOQL
query. These operators are AND, OR, and NOT. Parentheses are required whenever you mix the
operators.
The following table lists the logical operator values that are used in fieldExpression syntax:
Operator | Syntax | Description |
---|---|---|
AND | fieldExpressionX AND fieldExpressionY | true if both fieldExpressionX and fieldExpressionY are true. |
OR | fieldExpressionX OR fieldExpressionY |
true if either fieldExpressionX
or fieldExpressionY is true. In a WHERE clause that uses OR, records are returned even if the foreign key value in a record is null.
|
NOT | not fieldExpressionX |
true if fieldExpressionX
false. There’s also a comparison operator NOT IN, which is different from this logical operator.
|