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

[B_ Normann P_ Nielsen]

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

[Udo Brand · Accepted solution]

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)"

[B_ Normann P_ Nielsen]

Excellent and Thanx :-)

[Serj Shcherbakov]

@Udo Brand thank you!

[Krishnan Iyer]

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