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 conditions display lists in Core UI as a breadcrumb, summarizing what you have selected.
Condition builder breadcrumb 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 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 in addition to the conditions. You can remove a condition by clicking the delete icon (X) next to the condition.
Example AND condition.
For an example of a scripted filter see the KB article Creating dynamic JavaScript filters in reports.
- Filtering on empty fields
Most filter operations do not return empty fields in their result set. You can create a filter that displays records with an empty field value in addition to records that match the initial filter conditions. - Values for date/time fields
When you filter on fields of type date/time, such as the Created field on any task record, several time-related options are available, such as Today, This week, Last 3 months, and so on. - Comparing field values
Field comparison allows users to evaluate equality between fields on the same table or on related tables by using operators in the condition builder.
Parent Topic:Create a condition statement using the condition builder
Related topics