Create a report a list of Normal Changes that do not have any CTasks?

[Shashi K]

Create a report a list of Normal Changes that do not have any change tasks included in them. Is it achievable using OOB reporting?

[AndersBGS · Accepted solution]

Hi @Shashi K ,

Yes it is - Create a report based on the change_request table and add a related list condition for change_task -> Change_request where you set the quantity equal to 0:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Shashi K]

Hi @AndersBGS ,

I have add State filter condition 

state is one of Review and closed 

it’s showing the Ctask 

why?

[AndersBGS]

Hi @Shashi K ,

Please share a snip of what you're referring - then it will be much easier to help you.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Shashi K]

Sorry @AndersBGS,

Now it’s working fine 

Thank you so much