How to display all Open Change requests where all tasks are closed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2020 08:44 AM
I need a Report to display all Open Change requests where all tasks are closed.... But I am not sure what filter condition I should use to get the change requests where all the tasks are closed. Normally in one change request there will be one or more tasks and also all the tasks may not be closed at the same time. And now i need a report where I want all the change request numbers in which all the tasks should be closed.
Can anyone please help me with the appropriate filter condition to produce the report.
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2020 09:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2020 09:10 AM
Switch to the new UI and use a Related List Condition. Here are some examples: https://community.servicenow.com/community?id=community_blog&sys_id=bd0eaa2ddbd0dbc01dcaf3231f96199e