OR conditions

The condition builder uses two different types of OR conditions: top-level and dependent.

Using a dependent OR condition, you can specify alternative criteria to a single operation. Dependent OR conditions work in the manner A and (B or C). When you have an OR condition in the query, the magnifying glass is no longer available. The conditions you put in the quick search headers are ANDed together. Having an OR makes it ambiguous as to where the new condition should go, for example before the OR, or after the OR.

For example, to return a list of all unassigned problem and incident records from the Task table, create a filter with a dependent OR on the Number field.

[Assigned to] [is] [empty] AND [Number] [begins with] [PRB] OR [Number] [begins with] [INC].

Figure 1. Dependent OR List v2

Figure 2. Dependent OR List v3

A top-level OR condition allows you to display the results of multiple filter criteria in a single list. Top level OR conditions work in the manner (A and B) or (C and D).

For example, to return a single list of all active incidents with a category of hardware, and all inactive incidents with a category of software, create two condition sets separated by a top-level OR condition.

[Active] [is] [true] AND [Category] [is] [Hardware]
Top level OR condition
[Active] [is] [false] AND [Category] [is] [Software]

Top level OR condition in List v2 — Figure 3. Top level OR List v2

In List v3, select the New Criteria button in the condition builder to create a new top-level OR condition.

Top level OR condition in List v3 — Figure 4. Top level OR List v3

Top-level and dependent OR conditions can be used together. Filters using both types of OR conditions work in the manner (A or B) or (C or D). By mixing AND conditions with top-level and dependent OR conditions, you can create very specific filters.

OR conditions

The condition builder uses two different types of OR conditions: top-level and dependent.

For example, to return a list of all unassigned problem and incident records from the Task table, create a filter with a dependent OR on the Number field.

[Assigned to] [is] [empty] AND [Number] [begins with] [PRB] OR [Number] [begins with] [INC].

Figure 1. Dependent OR List v2

Figure 2. Dependent OR List v3

A top-level OR condition allows you to display the results of multiple filter criteria in a single list. Top level OR conditions work in the manner (A and B) or (C and D).

[Active] [is] [true] AND [Category] [is] [Hardware]
Top level OR condition
[Active] [is] [false] AND [Category] [is] [Software]

In List v3, select the New Criteria button in the condition builder to create a new top-level OR condition.

How search works:

Topics are ranked in search results by how closely they match your search terms

OR conditions

OR conditions

On this page

OR conditions

OR conditions

Log in to personalize your search results and subscribe to topics