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

JQL to find parents where all subtasks are resolved

Hello,

Is there a JQL function (native or via Script Runner) that would allow to find all the issues that have all their SubTasks resolved?

Thanks in advance for your help.

Gianni

2 answers

1 accepted

Hi Gianni, 

Look at this asnwer JQL: Find all open issues of type "Issue Tracker" where all subtasks are closed or resolved

If you have script runner installed, a query like this will give you all the issues that have all their subtasks done.

issuefunction in parentsOf("type in subtaskIssueTypes()") and not issuefunction in parentsOf("resolution = Unresolved")

I tested it and it works for me.

Regards,

Konstantin

Like BarL likes this
2 votes

Install scriptrunner and use the following query. 

 

issuefunction in parentsOf("issuefunction in subtasksOf(\"issuefunction not in parentsOf('type in subTaskIssueTypes() and status != closed')\") ")

Thanks, this works too but in my case the one by Konstanting is more readable. Working on resolution instead of status of subtasks was fine too.

Suggest an answer

Log in or Sign up to
This widget could not be displayed.
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