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.
This is a known bug. Please raise the visibility of this deficiency by voting for this issue: https://jira.atlassian.com/browse/JRASERVER-63848
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.