Related List Conditions in Reporting

Justin Nelson
Tera Contributor

There is the option to use "Related List Conditions" in List views using List V3. See ServiceNow documentation on Related List Conditions.

The problem being that a lot of end users are attempting to build Reports and start asking how they can use related lists to filter more in-depth. An example:

I need to be able to report on all Incidents that have an associated Problem Record, but where the Incident record has an attached knowledge article. You can do this using a list view from the Incident Table as seen in the below example:

find_real_file.png

From the Reporting Feature, I need to be able to do the same and do a "Trending" report:

find_real_file.png

The problem being, that there is no way to add a "Related List Condition" filter on the Report. I was unable to find any documentation on this specifically, in the ServiceNow Knowledge Base or on the community. I'm curious if others have had the same problem or have figured out a work around. Does Snow have any plans to address this? This would be GREAT functionality for use reporting geeks!

Another kicker, is that you can build Indicators in Performance Analytics that use Related List Conditions. Why can we not do this in two other areas of the platform, but not reporting, where it would be most valuable?

1 ACCEPTED SOLUTION

This is great, thanks Adam. I'll look into Scripted Filters. Although, I'm not a developer, nor do I have much experience with scripting...



After playing with it a little bit more. The New UI for Reporting includes the ability to use Related List Conditions. See below:


find_real_file.png


Funny how digging around can identify solutions!


View solution in original post

3 REPLIES 3

Adam Stout
ServiceNow Employee
ServiceNow Employee

Related List Conditions are awesome.   Once you use them you just want more and more and more.   But they don't do everything.



You can solve this with a Scripted Filter.   Take a look at this article:



Make Complex Reporting Easier using Query Techniques


This is great, thanks Adam. I'll look into Scripted Filters. Although, I'm not a developer, nor do I have much experience with scripting...



After playing with it a little bit more. The New UI for Reporting includes the ability to use Related List Conditions. See below:


find_real_file.png


Funny how digging around can identify solutions!


Hi, 

I do have one of the similar requirement for mine like I want to pull a report on how many Knowledge Articles are attached to an Incident based on the Related List Tab named "Related Knowledge".

But I don't find any option to pull that field in the new UI report view.

Can you please help me on the same?

 

Thanks