Related List Condition

The purpose of related list conditions in ServiceNow reporting is to filter parent records based on the data in child records through the Condition Builder. For example, you can find all Problems that have at least one related Incident/Cases with specific affected configuration items. This improves reporting accuracy because you are able to query across related tables. 

When to Use Related List Conditions

---

Use related list conditions when you need to find parent records that have or do NOT have specific related child records. Common use cases include finding incidents with specific affected CIs, Problems with zero related incidents, Tasks that have breached SLA, or Users with specific assigned assets.

Limitations

1. Dynamic filters and advanced dot-walking may not work in related list conditions

2. Using related list conditions on large tables can impact report performance

3. For complex scenarios involving multiple relationships, database views generally perform better

How to Add a Related List Condition

---

Procedure A: Creating a New Report with Related List Conditions

1. Navigate to Reports > Create New
2. Select the table for the parent record
3.  In the Filter section, select Add Filter Condition
4. In the first dropdown, find and select Related List Conditions
5. In the secondary form that appears, choose the child table under Related List
6. Define your filter criteria under Condition
7. Clock Run to generate the report

Procedure B: Adding to an Existing Report

1. Open the existing report in Report Designer
2. Navigate to the Filter section
3. Follow steps 3-7 from Procedure A 

An Example Report can be found in the data visualization library as 'User, Active, ITSManagers, List'