And/Or

and

If you select and, both conditions must be fulfilled.

Then, all contacts are displayed with the first name Joe and the second name Bloggs.

or

If you select or, then only one of the two criteria must be fulfilled.

Now, you will see all contacts with the first name Joe and any other last name. Now, you will see all contacts with the first name Joe and any other last name.

More than two filter criteria

You may want to create a filter with more than two filter conditions that are connected with and as well as with or.

In this case, a similar rule to the mathematical order "multiplication before addition" applies. This means that without the brackets the first and connection would be compared with the first or connection. The result would then be compared with the next or connection, and so on.