Logical Operators and Groupings

If you set up a user-defined filter containing several criteria, you can link these criteria in two different ways: by using operators and/or groupings.

Logical Operators "and" and "or"

  • You can use the operators "and" and "or" to link two criteria with the help of logical operators:
  • Operator "and": The operator "and" links the currently selected criterion with the preceding criterion. Both criteria must be fulfilled.
  • Operator "or": The operator "or" also links the currently selected criterion with the preceding criterion. However, only one of the two criteria needs to be fulfilled.

Example:

You create a new filter with Criteria A and B.

Example with "And"
Example with "Or"
If you use the operator "and" to link the two criteria, both criteria must be fulfilled. In other words, the entries or terms searched for with this filter must match both Criterion A and Criterion B.
If you use the operator "or" to link the two criteria, only one of the criteria needs to be fulfilled. In other words, the entries or terms searched for with this filter must fulfill either Criterion A or Criterion B.

To select an operator, first select the criterion for which you want to set the operator. Then select the operator from the drop-down list of the corresponding column:

wiz_cTank-maintenance-Wizard_operator-auswaehlen
Tip

If you do not explicitly select any logical operator, the operator "and" will automatically be used.

Priority of the operators

If several criteria are linked with the operators "and" and "or", the operator "and" always has priority over the operator "or".

Example 1

You create a new filter with Criteria A, B, C, and D. The criteria are linked as follows:

Operator
Criterion
Criterion A
and
Criterion B
or
Criterion C
and
Criterion D

As the operator "and" has priority over the operator "or", the Criteria A and B or the Criteria C and D must be fulfilled. In other words:

((Criterion A and Criterion B) or (Criterion C and Criterion D))

Example 2

You again create a new filter with Criteria A, B, C, and D. In this case, the criteria are linked as follows:

Operator
Criterion
Criterion A
and
Criterion B
and
Criterion C
or
Criterion D

As the operator "and" again has priority over the operator "or", the Criteria A, B, and C or Criterion D must be fulfilled. In other words:

((Criterion A and Criterion B and Criterion C) or Criterion D)

To change the linking of the operators, you can group the criteria.

Groupings

Like logical operators, groupings can also be used to link criteria. Especially when using several criteria, criteria grouping allows a more transparent criteria structure. Moreover, the function of the utilized operators can also be influenced, as groupings have priority over operators.

Example:

You create a new filter with Criteria A, B and C. In this case, the criteria are linked and grouped as follows:

Grouping
Operator
Criterion
icn_cTeM_operator_gruppierung
Criterion A
or
Criterion B
and
Criterion C

As the grouping has priority over the operators, Criteria A or B, and then Criterion C must be fulfilled. In other words:

((Criterion A or Criterion B) and Criterion C)

Without the grouping, the Criteria A or the Criteria B and C must be fulfilled. In other words:

(Criterion A or (Criterion B and Criterion C))

Creating groupings

To create a grouping, select the criteria you want to group via multiple selection, e.g. by keeping the Ctrl key pressed. From the context menu that you can access by clicking the right mouse button, select the item Group.

The grouping is displayed in the form of square brackets comprising the grouped criteria.

wiz_cTerm-filter-wizard_gruppierung

It is also possible to implement multi-stage groupings.

To remove the grouping, select the grouped criteria and select the item Ungroup from the context menu.