This site is moving soon to become part of an integrated Appfire documentation and information site for our apps. This site will remain available during the transition to our new and improved site. Once this site is moved over, this banner will be updated with the new site link for easy access.
Take a look here! If you have any questions please email support@appfire.com
Jira Hierarchy & Advanced Roadmaps JQL Functions
- Daniel Turczanski
- Deborah Scott
The instructions on this page describe how to execute a JQL search using JQL Search Extensions.
Jira Hierarchy JQL Functions
JQL functions are accessible from Extended Search screen or via Extended Search filters in Jira advanced search.
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 childrenOfIssuesInQueryRecursive("assignee=currentUser() and type=Initiative", 2) finds epics and stories of all of my epics and skips the subtasks.