I want to export issues to excel.
I am using subtasks.
I want to order the subtasks by their parent, report on them by parent task, etc. (in excel)
Therefore, it would be good to get the parent key in the export.
AFAICS, there is no parent key column or similar that can be exported.
Surely, this must be possible?
How else is one to use the excel export to view and report on parent-subtasks?
Any help appreciated.
Not much - I use a scripted field (ScriptRunner) which reads the current issue and echoes out the parent issue summary and/or key on all sub-tasks, and the parent (slightly annoying as it's duplicated data on the parent, but it lets you sort and export the data easily, so hey)
Including a parent reference in the dataset has been rejected by atlassian, this is the "new feature" that was rejected:
Links Hierarchy exports issues into Excel by preserving the hierarchy in a very flexible way as you can visualize the hierarchy in JIRA previously, apply filters, expand/collapse children, etc and once you view the right data then just click on the "Export to Excel" menu and Links Hierarchy will create a powerful report with support for expand/collapse (from Excel!!!), configure issue fields to export, etc.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot