Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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?

2 answers

3 votes

Hello,

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

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

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
Thomas

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:
image.png

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

Hi,

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.

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!
Daniel

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
TAGS

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