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

kavitha_cr
Mega Guru

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

2 REPLIES 2

sachin_namjoshi
Kilo Patron
Kilo Patron

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

Adam Stout
ServiceNow Employee
ServiceNow Employee

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