...
issue in subtasksOfParentsInQuery("status='Done'") and status='To Do'
finds subtasks that are in progress and have finished parentsissue in subtasksOfParentsInQuery("assignee=currentUser()")
finds subtasks of my issues
ParentsOfIssuesInQuery
For a given JQL subquery it finds parents of resulting issues. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierachy Epic → Story → Subtask.
Also have a look at ParentsOfIssuesInQueryRecursive.
Examples:
issue in parentsOfIssuesInQuery("project='ACME' and type=Epic")
finds all parents of epics in project ACME. Parents of epics are usually called Initiative.issue in parentsOfIssuesInQuery("assignee=currentUser()")
finds parents of all of my tickets.
ParentsOfIssuesInQueryRecursive
For a given JQL subquery it finds issues in the hierarchy above the resulting issues up to an optional depth. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierachy Epic → Story → Subtask.
Examples:
issue in parentsOfIssuesInQueryRecursive("project='ACME' and type=Epic")
finds all parents of epics in project ACME, and parents of parents, and so on. Parents of epics are usually called Initiative.issue in parentsOfIssuesInQuery("assignee=currentUser() and issueType in subtaskIssueTypes()", 2)
finds parents of my subtasks and epics of the parents, skips anything above epics.
ChildrenOfIssuesInQuery
For a given JQL subquery it finds children of resulting issues. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierachy Epic → Story → Subtask. Also have a look at ChildrenOfIssuesInQueryRecursive.
Examples:
issue in childrenOfIssuesInQuery("project='ACME' and type=Initiative")
finds all epics in initiatives in project ACME.issue in childrenOfIssuesInQuery("assignee=currentUser()")
finds children of all of my tickets.
ChildrenOfIssuesInQueryRecursive
For a given JQL subquery it finds issues in the hierarchy below the resulting issues up to an optional depth. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierachy Epic → Story → Subtask.
Examples:
issue in childrenOfIssuesInQueryRecursive("project='ACME' and type=Initiative")
finds all epics, stories and subtasks in initiatives in project ACME.issue in childrenOfIssuesInQuery("assignee=currentUser() and type=Initiative", 2)
finds epics and stories of all of my epics and skips the subtasks.
Permissions and feature availability to users
...