Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Filter for open subtasks where parent is closed

Could someone please help me to figure out a filter that will allow me to see all parent issues in all projects that are closed but the subtasks are open?

3 answers

3 votes


You would need an add-on for it. For example, you could use the Power Scripts add-on:

You could write the following JQL query:

key in hasSubtasks("status = Open") and status = Closed

Hi Alexey,

i tried with Power Scripts. The module hasSubtasks is enabled.


The query

project = "TEST" AND key in hasSubtasks("status = Backlog") and status = Done

does not find issues. But there are some.


Is there anything else I need?


Best regards

Hello @Thomas!

You do not need something else. Could you paste a screenshot of an issue, which is in the TEST project, the status is Done and it has a subtask or subtasks, which are in the Backlog status? 

Hello Alexey,

here is the screenshot:

Projektkey here is ITSD

Then your JQL query should be

project = "ITSD" AND key in hasSubtasks("status = Backlog") and status = Done

yes, but there are zero results 

interested in this query too


this query works for me:

key in parentsOf("project = \"YOUR Projectname\" AND status = Backlog") AND status = Done

I am getting below error. How to resolve the issue

Unable to find JQL function 'parentsOf(project = "Project Management" AND status = Backlog)'.

You need Power Scripts add-on.

Can smbd please help in writing JQL query filter for closed Story and Task but opened subtasks (statuses re-opened, blocked for development, code review, ready for retesting, testing) to find it quick?

Hey @Suresh_Kumar ,

If it's a one-off job you can always export the issues to a spreadsheet and do your analysis there.

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions.

This query finds finished issues with unfinished subtasks.

issue in parentsOfSubtasksInQuery("resolution is empty") and status='Done'

I hope this helps!

Thanks for letting me know. I got it and able to see the results with search extensions

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you