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:

  • "Product equals XYZ"  AND
  • "Owner equals ABC"  OR
  • "Priority equals P1"

This search will be executed by your Accompa system as:

("Product equals XYZ" AND "Owner equals ABC") OR "Priority equals P1"

Similarly, if you enter the following criteria in the same order shown below:

  • "Product equals XYZ"  AND
  • "Owner equals ABC"  OR
  • "Priority equals P1"  AND
  • "Module equals KLM"

This search will be executed by your Accompa system as:

(("Product equals XYZ" AND "Owner equals ABC") OR "Priority equals P1") AND "Module equals KLM"


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:

"Product equals XYZ" AND ("Owner equals ABC" OR "Priority equals P1")

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):

  • (
  • "Product equals XYZ"  ) AND (
  • "Owner equals ABC" OR
  • "Priority equals P1"
  • )

The real power of  ) AND ( , ) OR ( options can be seen when you need complex criteria such as: 

(Criteria-1 OR Criteria-2 OR Criteria-3) AND (Criteria-4 OR Criteria-5 OR Criteria-6)

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):

  • (
  • Criteria-1 OR
  • Criteria-2 OR
  • Criteria-3 ) AND (
  • Criteria-4 OR
  • Criteria-5 OR
  • Criteria-6
  • )