How to export all issues in an epic including subtasks?

Question

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.

Graeme Burnett_d5w7hz · Answer

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.

Tim Hendry · Answer

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/

Kevin Mote · Answer

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