- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2018 01:43 PM
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:
From the Reporting Feature, I need to be able to do the same and do a "Trending" report:
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?
Solved! Go to Solution.
- Labels:
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2018 02:00 PM
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:
Funny how digging around can identify solutions!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2018 01:49 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2018 02:00 PM
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:
Funny how digging around can identify solutions!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2019 05:40 AM
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