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

[Bongani Hermans]

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_ · Accepted solution]

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:

"Epic Link" = LATAM-587 OR issuekey in subtasksOf(' "Epic Link" = LATAM-587 ')

*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 <3

Kind regards

[Bongani Hermans]

Hi Jack_Nolddor__Sweet_Bananas_,

Thanks for the feedback - we have a scriptRunner plugin, can't we implement the desired solution using scriptRunner?

Please advise.

Regards

Bongani

[Jack Nolddor _Sweet Bananas_]

Sure, just use issueFunction instead and should work:

"Epic Link" = LATAM-587 OR issueFunction in subtasksOf(' "Epic Link" = LATAM-587 ')

Regards

[Bongani Hermans]

I am getting an error - is there something I need to include mybe?

[Jack Nolddor _Sweet Bananas_]

Hi,

The filter I provided need to be typed within the Advanced Search

[Bongani Hermans]

Hi @Jack Nolddor _Sweet Bananas_ 

Thanks it worked - much appreciated.