The Matching option determines how the Conditions you have defined are evaluated and combined for a final result that will include or exclude a data set record. For instance, you may want a record to be filtered out if any of your conditions are met or only if all of them have been satisfied. You can also perform more advanced matching as well. Whether the record is included or excluded once your conditions have been matched will be determined by the Inclusion you set. The Matching options are discussed below:
Match ALL of the Conditions
The Inclusion you specify for this question (including or excluding) will be taken only when all of the listed Conditions are satisfied. This is equivalent to having an AND operator between all of the conditions.
Match ANY of the Conditions
The Inclusion you specify for this question (including or excluding) will be taken only when any of the listed Conditions are satisfied. This is equivalent to having an OR operator between all of the conditions.
Match CUSTOM Combination of Conditions
Sometimes you may need to include or exclude a record based on more complicated condition matching than "any" or "all". In these cases, you can customize an expression that tells us how to match your conditions. When you select this option, a textarea will appear that allows you to type in your custom expression. The syntax for this expression is discussed below.
Each condition will have an identifying number to its left. The first condition will be 1, the second 2, and so on. These numbers will be used within your custom combination in order to identify individual conditions. The operators you may use are AND, OR and NOT. For example, let's assume you have defined three conditions and you wish to exclude a record when either condition 1 is true or also if condition 2 is true, but condition 3 is false. You would enter your custom combination as:
1 OR (2 AND (NOT 3))
The parentheses are used to determine the order of evaluation. The content inside the parentheses are evaluated first before the surrounding conditions. So in the example above, the condition (NOT 3) will be evaluated first and combined with (2 AND (NOT 3)) prior to the overall condition of 1 OR (2 AND (NOT 3)).