How to export all issues in an epic including subtasks?

Svein Seldal June 17, 2014

We are about to release a product, and I have been asked to generate a report (ASAP) of all issues belonging to an epic, *including* it's sub-tasks. The Export Full content function in the issue viewer nearly does the trick, but it does not include the sub-tasks.

How can I do this? The epic is big, so finding all sub-tasks in a tedious job.

5 answers

6 votes
Kevin Mote
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 7, 2018

This is a known bug. Please raise the visibility of this deficiency by voting for this issue: https://jira.atlassian.com/browse/JRASERVER-63848

1 vote
Tim Hendry March 5, 2020

I found that if you use the "parentEpic()" function you can get list of all tickets under a particular epic including sub-tasks.  I.e. with a simple query "parentepic = ticket-123".  You can then export this full list to CSV and open in Excel. This file should include columns called "Issue ID" and "Parent ID".  Once in Excel I wanted to do a sort to group all sub-task rows beside their parent ticket row.  There may be a simpler way to do this but to achieve this I added a new column in my spreadsheet called 'Parent Ticket ID' with a formula equivalent to '=IF(ParentID="",IssueID,ParentID)' added per row for all rows.  I was then able to do a multi-column sort by this new 'Parent Ticket ID' column and the IssueID column to achieve the grouping I wanted.  This page has a handy list of other JQL functions: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

0 votes
Graeme Burnett June 30, 2020

Similar to above but with the epic

key = yourEpic OR "Epic Link" = yourEpic order by key asc

This produces a key ordered list which can then be exported to work (which in my case was needed for internal audit. To include the sub-tasks:

key = yourEpic OR ("Epic Link" = yourEpic and type IN (Epic, Task, Sub-Task)) order by key.

The order by key works because I automatically create the epic then tasks using a pyJIRA approach so I know they will present in the right order.

Then export to your favourite content type.

0 votes
Pedro Rodrigues July 7, 2014

Hi Svein,

The Xporter for JIRA plugin (https://marketplace.atlassian.com/plugins/com.xpandit.plugins.jiraxporter) is a great solution for you. You can export one or multiple issues in many formats (such as: DOCX, PDF, ODT, SVG or RFT) and you can use sample templates or you can create and define one according to your desired results.

Try it now.

Best Regards,

PMRodrigues

0 votes
Danilo Conrad
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 17, 2014

Hi Svein,

You may use a JQL to search for all the issues you want in the Issue Navigator, as described in the related post below:

https://answers.atlassian.com/questions/177329/jql-to-show-all-issues-and-subtasks-in-the-epic

Afterwards, you may export the results to Excel by following the steps on the document below:

https://confluence.atlassian.com/display/JIRA/Exporting+Search+Results+to+Microsoft+Excel

I hope this helps.

Cheers,

Danilo

Kevin Mote
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 7, 2018

I have confirmed (in 7.3.1) that these instructions do NOT work for subtasks. This is a known bug. Please vote for this issue: https://jira.atlassian.com/browse/JRASERVER-63848

Suggest an answer

Log in or Sign up to answer