Filter Logic Tips

Use the following tips when entering filter logic:

Filter logic examples
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.