How are "Advanced Search" or "Filter" criteria combined when I enter multiple criteria? |
When you enter multiple search/filter criteria in "Advanced Search" or "Edit SmartView" page - they are combined using the logic described below. 1) When you use AND , OR options to combine the criteria: The criteria are applied one at a time, in the same order you enter them. Examples: For example, let us say you enter the following criteria in the same order shown below:
This search will be executed by your Accompa system as:
Similarly, if you enter the following criteria in the same order shown below:
This search will be executed by your Accompa system as:
2) When you use ) AND ( , ) OR ( options to combine the criteria: The criteria are applied based on the locations of the parentheses. When selecting one of these options - imagine that there is an opening parenthesis before the first criteria, and a closing parenthesis after the last criteria. Examples: Let us say you were interested in the following:
You can achieve this by entering the criteria as shown below (the parentheses in the first and last line are automatically added, you don't have to enter them):
The real power of ) AND ( , ) OR ( options can be seen when you need complex criteria such as:
You can achieve this by entering the criteria as shown below (the parentheses in the first and last line are automatically added, you don't have to enter them):
|