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