Here you find an explanation about the existing search operators to adjust filters in TABLE|IT:

 

 

(1) and: when you use the condition "and" all of the criteria you entered have to be fulfilled

 Example: You enter the billing date 05.03.2020 and the company "CRMADDON Factory GmbH". Only those entries of the table will be displayed where the billing date is 05.03.2020 and the company is "CRMADDON Factory GmbH" as well.

 

(2) or: when you use the condition "or" at least one of the criteria has to be fulfilled

 Example: You enter  the billing date 05.03.2020 and the company "CRMADDON Factory GmbH". You will get those entries where either the billing date is 05.03.2020 or the company's name is "CRMADDON Factory GmbH" and of course all of the entries where both are fulfilled.

 

(3) not and: no more than one criterion can be fulfilled at the same time

 Example: You enter  the billing date 05.03.2020 and the company "CRMADDON Factory GmbH". You will get the entries where only one of the criteria is fulfilled. Entries where the billing date is 05.03.2020 and the company is "CRMADDON Factory GmbH" will not be displayed.

 

(4) not or: none of the criteria have to be fulfilled

 Example: You enter  the billing date 05.03.2020 and the company "CRMADDON Factory GmbH". You will get all of the entries where both the billing date and the company are different.

 

For curious users: These operators are based on the so called logic gates.