How to display all Open Change requests where all tasks are closed.

kavitha_cr
Mega Guru

‎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.

find_real_file.png

Labels:
Preview file
28 KB
0 Helpfuls
  • 2,649 Views
2 REPLIES 2

sachin_namjoshi
Kilo Patron
Kilo Patron

‎07-08-2020 09:08 AM

Configure below report

 

- Navigate to change_task.LIST on your navigator.

- Apply below filters to see active change requests even if change tasks are closed

 

find_real_file.png

 

Regards,

Sachin

Preview file
135 KB
0 Helpfuls

Adam Stout
ServiceNow Employee
ServiceNow Employee

‎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

0 Helpfuls