How do we extract all issues with their sub-tasks linked to an epic?

Bongani Hermans_2opknp

We would like to pull a report using JQL on all issues linked to an epic,

Display Epic with all issues linked to it, level to inherit the values from the epic/SAFE epic.

We would like to see the epic plus its issues.

Jack Nolddor [Sweet Bananas]

Hi Skye,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

 

First, retrieve all issues linked to an Epic, i.e.:

"Epic Link" = LATAM-587

 

Then you can use this as a subquery on subtasksOf() jql function to also retrieve subtasks of above issues, as shown below:

<span><em>"Epic Link" = LATAM-587 OR </em></span><span><em>issuekey in subtasksOf(' "Epic Link" = LATAM-587 </em>'</span>)

*Note that this is just an exaple, you must tune your query to fit your needs

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

 

References:

• Official documentation

 

Hope this helps you to create awesome queries

Kind regards