How to export to excel with parent column?


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.

3 answers

1 accepted

This widget could not be displayed.

I've used simple derived custom fields to do this in the past (requires a bit of code - I've always done it with a really basic plugin, but I think it can be done with the script-runner addon as well)

Yeah, it seems that workarounds are needed again. Thanks Nic.

Hi Nic. Can you please elaborate your procedure to solve the parent subtask reporting?

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)

This widget could not be displayed.

Including a parent reference in the dataset has been rejected by atlassian, this is the "new feature" that was rejected:

Lets hope that they reconsider. Most packages process data with parent references in a more direct and natural way.
This widget could not be displayed.

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.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

143 views 2 0
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you