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

Question

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 · Answer

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

ABCDIssue TypeIssue keyParentSummary

Sub-Task Sheet Structure

A

B (new column)CKey

Sub-task ParentSummary

TA-DA!

May the odds be ever in your favour!

jndeverteuil · Answer

Please see edited anwser :)

Darryl Beckett_0k5o0h · Answer

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.