Add related list conditions
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
-
To select a quantifier, select Greater Than Or Equal To 1.
The Quantity popover opens.
- Optional:
Enter one or more conditions for the related table.
Select New Criteria to add another condition.The following image shows the example of filtering for problem records with more than two related incidents that are critical priority.Note:You cannot perform a keyword search in a related table condition.