Finding all RITMs with no active TASKs

Gaetano Ferrara
Giga Contributor

I need to create a report to find all RITMs (parent) that contain no active TASKs (child).

I know how to get information about a parent from a child by using things like "Parent.Updated", but not the other way.

Is there something like that I can use like "Child.Active" and then check for True/False?

1 ACCEPTED SOLUTION

Adam Stout
ServiceNow Employee
ServiceNow Employee

This should be straight forward with a Related List Condition.  I don't see what you would need a view for this.

find_real_file.png

View solution in original post

6 REPLIES 6

Which options are you talking about?  Related List Conditions are available in the Report Designer (but not the legacy Report Builder).

Was using the legacy report builder, now used the report designer, works, thanks!