Jira export - Parent to show epic link instead of parentId

[Johnnie_Li]

Hi, 

Parent value shows the ParentId (123456) in Jira export. The parentId is not used on the frontend. We used to be able to use `Epic link` to show the epic ID. But it is being replaced with Parent. Is that a way to show the ticket ID instead (i.e. ABC-123).  

Thanks in advance.

Johnnie

[Aron Gombas _Midori_]

It is a shortcoming that has been known for years.

Try the Better Excel Exporter app to get the parent's key in the output. Even better, the parent key will be exported as clickable link, like the issue's own key in column "A" below. If you don't like it, it can be turned off.

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

[Vishal Biyani]

@Johnnie_Li 

Based on Aron response, I understood what your issue is. If you export it in excel instead of csv, then you get issue key of Parent.

I have tried and it works for me i.e. clicking on Open in Microsoft Excel option gives me the parent key (but no parent summary :-(  ).

[Vishal Biyani]

@Johnnie_Li 

Your context is not clear.

Automation

If you are looking on how to get parent key in automation, then below will work

the smart value to extract parent key is {{issue.parent.key}}

Refer this article to know more about available smart values.

REST APIs

if you are using rest APIs to extract data, then parent will appear as a json object under fields that you will need to parse for key and id