Exporting a list of all issues in several epics

Question

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?

Pete Singleton · Accepted Answer

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

Jack Nolddor [Sweet Bananas] · Accepted Answer

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 Answer

@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.