Robert van Boesschoten
Published: 23-10-2019
Last updated: 27-08-2020
You can create complex filters by grouping certain conditions together in an AND/OR construction.
Each row you add to a filter contains a condition which is used to filter data. Multiple rows can be joined together with an `AND` so that condition A `AND` B must be true for a record to turn up. But you can also use an `OR` so that A `OR` B has to be true for a record to turn up. You can group rows together to make this more complex.
Now we have a filter that uses 2 condition rows, but what if we need a filter with even more condition rows? That is possible, but there is a catch. The conjunctions need to be the same within a group, and this is where grouping comes into play. Let’s continue with the filter that we have just created.
We have created a simple grouped filter with multiple condition rows. You can make these filters as complex as you want them to be.
We have conditions rows A, B and C with the following cases:
All must be true so: A `AND` B `AND` C
At least one must be true: A `OR` B `OR` C
A must be true, or B and C must both be true: A `OR` (B `AND` C)
A or B must both be true, or C and D must both be true, and E or F must both be true: (A `AND` B) `OR` (C `AND` D `AND` (E `OR` F) )