- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2018 01:21 PM
As the title says I'm struggling to get a report that shows resolved/closed incidents with and without associated incident tasks. I can only get it to give resolved/closed incidents with associated tasks but not when there is an incident without an incident task.
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2018 05:58 PM
This is my main use case for Related List Conditions. Here are the docs: https://docs.servicenow.com/bundle/kingston-platform-user-interface/page/use/using-lists-v3/task/cre...
You need to be using the Report Designer (the new UI) to get the new condition builder. With this, you are only a couple of clicks away from your report. You can also easily do things like having one report with "No Tasks" and other with "No Active Tasks" or perhaps "No Tasks Assigned to the Incident Assignment Group". A whole world of possibilities.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023 06:30 AM
Here's how you return Incidents with no tasks:
In the 'Related Conditions' section, it says 'Greater than/Less than 1' by default. Click it, and select 'None', and then run the query without selecting any more sub-conditions.
To return the incidents with no tasks, select the incident table in step 1, and in the 'Configure' step, select the range of incidents as your primary query. In the Related List Conditions, select 'None' - 'Incident Task - Incident'. Running this query should give you the correct list.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2023 06:05 AM
This link doesn't work anymore ... can we have a new link ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2023 06:40 AM
Same thing here, I'm not able to build a report for incidents with NO ITASK ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2023 12:48 AM
Here's how you return Incidents with no tasks:
In the 'Related Conditions' section, it says 'Greater than/Less than 1' by default. Click it, and select 'None', and then run the query without selecting any more sub-conditions.
To return the incidents with no tasks, select the incident table in step 1, and in the 'Configure' step, select the range of incidents as your primary query. In the Related List Conditions, select 'None' - 'Incident Task - Incident'. Running this query should give you the correct list.