nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL to return a list of issues where all sub-tasks within are the issue are all closed or canceled

Fatima Bernardo

I am a newbie at JQL and ask the community for help to come up with a query that returns a list of issues (in my cases Tasks) where the Tasks have sub-tasks within, but all of these sub-tasks are closed or cancelled (i.e. there's no open tasks that require attention).

Any advise?

Accepted answers

Alexander Bondarev_x6gjf3

Hi, @Fatima Bernardo !

As I know Jira doesn't have out-of-box JQL-funtion for your case.

I checked the Atlassian's docs about Advanced searching.

But you can get it from apps:

Scriptrunner -
Documentation link.

 and issueFunction in parentsOf("project = JRA and statuscategory in ("Done")issuetype = Task and statuscategory not in ("Done")

JQL Search Extentions -
Documentation link.

"Done")issuetype = Task and statuscategory not in ("Done") and issue in subTaskStatusCategory(

All comments

Alexander Bondarev_x6gjf3

Hi, @Fatima Bernardo !

As I know Jira doesn't have out-of-box JQL-funtion for your case.

I checked the Atlassian's docs about Advanced searching.

But you can get it from apps:

Scriptrunner -
Documentation link.

 and issueFunction in parentsOf("project = JRA and statuscategory in ("Done")issuetype = Task and statuscategory not in ("Done")

JQL Search Extentions -
Documentation link.

"Done")issuetype = Task and statuscategory not in ("Done") and issue in subTaskStatusCategory(

final_openshift Certi

Hi Fatima,

You can achieve this by using JQL Search Extension plugin , you can use the query issueType="Story" AND subtaskStatus ="Done" please refer to the documents it contains examples and other necessary information related to the usage of plugin

Alexander Bondarev_x6gjf3

Hello, Fatima,

Have you already tried? Do you need any help?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira