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 conditions display above lists in Core UI as a breadcrumb, summarizing what you have selected.

An image of the condition builder breadcrumb above a list in Core UI.
Note: The condition builder breadcrumb in Core UI list view can be truncated depending on the values of two system properties:
  • glide.ui.breadcrumb_max_entries: specifies the maximum number of items displayed in the breadcrumb, with a default of 10.
  • glide.ui.export.choice_list_max_characters: specifies the maximum number of characters displayed for a choice list within the breadcrumb, with a default of 80.

For more information, see KB1962280.

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. You can remove a condition by clicking the delete icon (X) next to the condition.

Figure 1. Example AND condition in filter
Example AND condition.

For an example of a scripted filter see the KB article Creating dynamic JavaScript filters in reports.