Condition builder
-
- UpdatedJul 4, 2024
- 2 minutes to read
- Vancouver
- Navigation and UI
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
- 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.
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.

For an example of a scripted filter see the KB article Creating dynamic JavaScript filters in reports.
Related Content
- Operators available for filters and queries
The system provides a set of operators for use with filters, condition builders, and encoded queries. The data type of a field determines what operators are available for it.
- OR conditions
The condition builder uses two different types of OR conditions: top-level and dependent.
- Filters
A filter restricts what records appear in a list by providing a set of conditions each record must meet to be included in the list.
- Dot-walking to data in related tables
Dot-walking provides access to fields on related tables from a form, list, or script.