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: Find all open issues of type "Issue Tracker" where all subtasks are closed or resolved

As an alternative to some groovy looping, is it possible to make a JQL (possible using https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-hasSubtasks() ) the give the result:

Find all open issues of type "Issue Tracker" where all subtasks are closed or resolved

 

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

2 votes
Answer accepted

So you want "Issue Tracker that have no subtask which are in a status different from closed or resolved:

issuetype = "Issue Tracker" and status not in(closed, resolved) and not issuefunction in parentsOf("status not in (closed, resolved)")

 Maybe add some addition conditions in parentsof function (project, issuetype).

Edit: forgot that issue tracker should be open as well. Added "and status not in (closed, resolved)"

Excellent and Thanx :-)

@Udo Brand thank you!

This JQL worked for me:

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

The above query makes sure that issues that do not have any subtasks are not returned

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