Condition builder

A condition builder constructs a condition statement with a series of contextually generated fields. Condition builders are used in many operations, such as creating filters, administering surveys, and administering access control.

Condition builder format

A condition consists of three parts:
  • Field: a choice list based on the table and user access rights. The choice list can include fields on related tables by dot-walking.
  • Operator: a choice list based on the field type. For example, in the Incident [incident] table, the greater than operator does not apply to the Active field but it does apply to the Priority field.
  • Value: a text entry field or a choice list, depending on field type. For example, in the Incident [incident] table, the Active field offers a choice list with the values true, false, and empty, while the Short Description field offers a text entry field.

The condition builder in the list filter has a different appearance in List v2 and List v3. In UI16, condition builders in forms can be configured to look and work like the List v3 condition builder.

Condition builder actions

You can add a dependent condition by clicking AND or OR next to the condition. You can add a top-level condition by clicking AND or OR on the condition builder toolbar above the conditions (List v2) or clicking New Criteria (List v3). You can remove a condition by clicking the delete icon (X) next to the condition (List v2). In List v3, you click the remove condition icon (⊝) next to the condition.

Figure 1. Example AND condition in List v2 filter
Example AND condition in List v2
Figure 2. Example OR condition in List v3 filter
Example OR condition in List v3