SECTIONSFilter Logic Tips
Use the following tips when entering filter logic:
- When you add filter logic, include all filter conditions in the Boolean expression.
- If you remove a filter condition, remove the corresponding number from the filter logic.
- Make sure all parentheses are closed.
- Enclose filter conditions that have priority in parentheses. For example, "(1 AND 2) OR 3" finds records that meet either both the first two filters or the third. While "1 AND (2 OR 3)" finds records that meet the first filter as well as either the second or third.
| Example | Description |
|---|---|
| (1 AND 2) OR 3 | Finds records that match both the first two conditions or the third. |
| 1 AND (2 OR 3) | Finds records that match both the first condition and either of the last two.
|
| (1 AND 2) OR (3 AND 4) | Finds records that match both the first two conditions or the second two conditions. |
| (1 OR 2 OR 3) AND 4 | Finds records that match any of the first three conditions that also include the last. |
| (1 AND (2 OR 3)) OR 4 | Finds records that match the last condition as well as those that match the first and either the second or third condition. |