Add subtask status to filter for Parent tasks

[Roshelle Coghlan]

We currently use this filter to get a list of all projects currently in the "Manufacture" status, we then have to manually click through the list to check if all of the subtasks are marked as "Done" or if any are still open.

JQL is currently "issuetype = ITP AND status = Manufacture order by created DESC"

Can we add a filter to only include parent projects whose subtasks are all marked as Done or Complete? I did try to look at previous questions but I know next to nothing about JQL.

[Jack Brickey]

Hi @Roshelle Coghlan , Welcome to the community.

JQL alone won't be able to accomplish your goal. Do you have a couple of options one of which is to use a third-party enhanced query addon such a scriptrunner or similar. another option would be to create an automation that would add a label to the parent issue once our children are marked as done. In that way, you could search for all issues with that label.

FYI, you refer to these parents as projects which is inaccurate terminology. Projects contain work items (issues). Work items consists of various types, including epic, story, task, subtask.

[Charlotte Santos -Appfire-]

Hi  @Roshelle Coghlan

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all parent issues in status Manufacture whose subtasks are marked as Done:

issue in parentsOfSubtasksInQuery("status=Done") AND type = ITP AND status = Manufacture

Please contact our support if you have any other questions about this query, or the app in general.

We’ll be happy to help you! 😉