Logical operators are typically used with multiple conditions in a criteria.
Each condition returns a boolean value, and the logical operators used to connect the conditions determine the overall boolean value of the criteria.
There are 3 types of logical operators:
&& (AND) - conditions on both sides must be met.
The following truth table shows the possible outcomes when you combine two conditions with AND. The table’s left column shows the truth values of the first condition, the top row shows the truth values of the second condition, and each intersection shows the AND outcome.
AND TRUE FALSE TRUE TRUE FALSE FALSE FALSE FALSE
|| (OR) - condition on any one or both sides needs to be met
The following truth table shows the possible outcomes when you combine two conditions with OR. The table’s left column shows the truth values of the first condition, the top row shows the truth values of the second condition, and each intersection shows the OR outcome.
OR TRUE FALSE TRUE TRUE TRUE FALSE TRUE FALSE
! (NOT) - condition should not be met. Unlike AND and OR conditions, it does not connect two conditions. Instead, it negates(reverses) a single condition.
The following truth table shows the NOT outcome in the second column, based on the truth value of the condition in first column.
Condition NOT True False False True
As suggested above, there are numerous combinations of conditions and operators that are possible.
- The expression within the innermost set of parentheses is processed first, followed by the next deepest, moving outward until all parentheses have been processed.
- Same logical operators in the expression will be processed left to right.
- Among logical operators, the order of the precedence is:
- NOT, AND and OR for all Zoho services, except Zoho Creator
- NOT, OR and AND for Zoho Creator.