How to get the Issue Key of a Parent to show on a subtask

[Darryl Beckett]

I have a project with many stories created to it and I have many sub tasks associated to each story. I am able to pull a CSV report of all these sub-tasks but I am having trouble mapping it back to the Parent story. The CSV has a "Parent ID" column

I'm looking for a way to populate the CSV extract with the "Issue Key" of the parent for each subtask and not the "parent ID"

Is anyone able to help?

[Lynette Delane]

I really needed to do this to clean up a project where everyone was doing different things.

I tried this but the XML wouldn't open in a useful format.

What I was able to do was copy and paste the result pages into excel because the parent key shows as a prefix to the summary and use excel to match the data.

This was a good solution because I only had 100 sub-tasks/ 3 pages of results.  This may be painful if you have many more pages or aren't great at Excel formulae.

Steps below:

1. Export my full issue list into Excel
2. Sort by Issue Type
3. Create a second sheet for Sub Tasks
4. Create a JQL just for the sub-tasks, including the Summary column in the results and then copy and paste the page results into the Sub Tasks Excel sheet
5. Clean up the excel removing additional rows & search boxes that copy over as objects (although to be fair, you don't have to do this, i just need clean sheets).
6. Used =LEFT(C2,13) to pull the parent key out of the summary field into new "Sub-task Parent" column (B).
6. Only for the sub-task rows, added an Index and Match onto the main sheet referencing the Key column for the match

IFERROR(INDEX('Sub-Tasks'!B:B, MATCH(A2,'Sub-Tasks'!A:A, 0)),"")

7. Copy and paste the results as values.

Main Issue Export Sheet Structure

A	B	C	D
Issue Type	Issue key	Parent	Summary

Sub-Task Sheet Structure

A	B (new column)	C
Key	Sub-task Parent	Summary

TA-DA!

May the odds be ever in your favour!

[jndeverteuil]

Hi Darryl,

What I can suggest is to export using XML and you will be able to see the parentID and key.

1. Go to Issues and enter your JQL
2. Choose Export > XML and save the file
3. Open Excel and load the XML file

You will be able to see the parent key and parentID as in this screenshot I just took :

[Darryl Beckett]

Thanks but maybe I am not clear...

My current export has: Summary, Issue Key, Issue ID, Parent ID

Due to certain access within my team, sharing of this extract I need to show the "Parent Issue Key". 

The Parent ID does nothing for my stakeholders.

Is there a way when exporting a list of sub tasks do have the parent issue key come through as well.

Please provide examples and steps.

[jndeverteuil]

Please see edited anwser :)