When creating an advanced filter, you can combine the filter conditions. By default, the filter conditions are combined with the AND (conjunction) operator. You can, however, also combine the conditions by using parentheses and the OR (disjunction) operator.
| Operator | Description |
|---|---|
|
AND |
A result must fit all filter conditions. Example A AND B AND C means that only a resource that fits all three filter conditions is added to the results.
|
| OR |
A result must fit one of the filter conditions. Example A OR B OR C means that whenever a resource fits one of the three filter conditions, it is added to the results.
|
| ( ) |
A result must be a combination of something inside of the brackets and something outside of the brackets. Example A AND (B OR C) means that whenever a resource fits either B or C, and it also fits A, it is added to the results. Results can be a combination of either B and A or C and A resources.
|
A filter uses the following operator precedence to filter the data:
- Operations inside parentheses
- AND operations
- OR operations
Filter rule examples
- A OR B AND C:
- First, check the AND operation. The result must fit condition B and C.
- Second, combine it with condition A. The result must fit either A or the result of the AND operation.
- (A OR B) AND C:
- First, check the operation between parentheses. The result must fit either condition A or condition B.
- Second, combine it with condition C. The result must fit condition C and the result of the operation between parentheses.