Combined condition

The combined condition is used if several conditions are to be linked using a logical operator other than AND. (The logical operator And is automatically implied if multiple conditions are referenced in a condition attribute)

Configuration:

Property

Description

Logic operation (objects)

If the condition is executed on multiple objects, you can use the Logical operation(Objects) property to determine how the results of the condition (true or false) are linked and evaluated:

  • OR: Condition is true if one of the results or all results are true.

  • AND: Condition is true if all results are true.

  • Exclusive OR: Condition is true if one of the results is true and the rest are false.
Queries

You can create a query here which determines the objects for which the condition is evaluated.

If the condition is to be executed on objects that are referenced in another object, you can create a query here that determines the corresponding objects.

Conditions

Reference or create the conditions to be combined here.

Logic operator (conditions)

Select here the logical combination of the results of the combined conditions.
Variables

You can activate the enabled attributes of a query and condition in the Variables property so that they can be changed by users at the time of execution.

See also: Chapter Variables.

Example: Find objects with a specific combination of values

A condition filter is used to search for all employee objects for which both the first name and the last name have been entered.

Configuration:

The condition filter is configured as follows:

  • A reference query is created under Queries, which searches for all employees.

  • A combined condition is created under Conditions.

The combined condition is configured as follows:

  • Logical operation (objects): Or

  • Logical operation (conditions): And

  • Under Conditions, the following Set conditions are created:

    • Set condition that queries whether the value Name is set.

    • Set condition that queries whether the First name value is set.

Result of the condition filter query:

As an intermediate result, the reference query returns all employee objects. For each employee, the combination condition is executed with the two AND-linked Set conditions "Name AND first name defined".

Because the combined condition has the logical operation (objects) = OR, it returns results at the condition filter level, since the combined condition is true for at least one object. Thus, the final result only provides the employees with first and last names.