Exporting a list of all issues in several epics

[Ella_Pestine]

I'm trying to make a list of issues within several epics based on the label given to the epic. What is the best way to export a list of all issues in epics where label = x?

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Ella_Pestine,

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:

Search for all issues in Epics with an specific label

issue IN issuesInEpics("type = Epic AND labels = X")

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

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

References:

• Official documentation

Once you create a filter using the provided search you can export the results in differents format, please check Searching for issues page for further information about how to export the filter results into a file (CSV, XML, PDF,...).

Hope this helps you to create awesome queries <3

Kind regards

[Muhammad Ramzan(Atlassian Certified Master) · Accepted solution]

@Ella_Pestine , unfortunately to do that you need a third party plugin. I used Scriptrunner & JQL Search Extensions for Jira & reports 

If you use JQL Search Extensions for Jira & reports , following query will get your required results.

issue in allIssuesInEpic("labels='mylabel'")

Results: It will get all epics and their issues who have the label "mylabel" if you want filter further you can add issuetype to get on specific issues.

[Pete Singleton · Accepted solution]

You will need a plugin (e.g ScriptRunner) which allows you to execute sub-queries in JQL.