Report on open change request where all the task is closed

[Gintarevvv]

If there is at least one closed change task, it will be included in the results, regardless of any remaining open change tasks for the same change request. However, I need to retrieve all change request tickets only when all change tasks are closed.

[Mark Manders · Accepted solution]

You can use related list conditions. Report on the change_request table, with related list condition of change_task where state is on of the open states and a condition of less than or equal to 0. This will only show you the changes without open change tasks.

[Mark Manders · Accepted solution]

You can use related list conditions. Report on the change_request table, with related list condition of change_task where state is on of the open states and a condition of less than or equal to 0. This will only show you the changes without open change tasks.

[Gintarevvv]

After reviewing various posts for a similar question, this is the first correct answer. Thank you

[AndersBGS · Accepted solution]

Hi @Gintarevvv ,

I agree with @Mark Manders approch except that you need to add the open condition / not closed condition to your change request, as you would like to see "all open changes where all change tasks are closed":

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

Best regards

Anders