Add related list conditions
-
- UpdatedAug 3, 2023
- 4 minutes to read
- Vancouver
- Navigation and UI
Related list conditions allow you to include a relationship with another table in the filter. Related list conditions are supported in both List v3 and the Report interface.
Before you begin
Role required: none
About this task
You can optionally include conditions on the related table. For example, you can filter active problems with one or more related incidents that are in the Canceled state. Another example is to filter incidents with a breached service level agreement (SLA).
The List v3 filter contains two sections, one for the current table conditions and one for related lists conditions. You can include only one related table in the query, however, you can add multiple conditions for that table.

The easiest way to understand the parts of a related list condition is to use an example. The steps below use the example of open problems with some number of related incidents. You can perform these steps for any list view that supports List v3.
Procedure
Result

Related Content
- Create a filter in List
You can create a filter to restrict what records appear in a list by providing a set of conditions. When you run the filter, only records that meet the specified conditions are listed.
- OR conditions
The condition builder uses two different types of OR conditions: top-level and dependent.
- Filter on multiple string values
For a string field, you can create a filter that searches for multiple values by creating a comma-delimited list.
- Dynamic operators
The dynamic operator, is (dynamic), lists predefined dynamic filter options where the condition value is computed from a value in a reference field.