Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Filter shows Parent Key, but not Export

When I create a Filter (or Query) of subtasks, Jira includes the Key of the parent issue in the Summary field (see blue block in image).

When I export the results to Excel the parent's key is no longer part of the data.

Is it possible to keep / include the parent key in the export?


2022-08-12 08_07_13-[JCM-187].png


As an alternative I've though to copy the parent's key to a custom field of the subtask (upon creation) and then to add this field to the Filter, but then all the existing subtasks' custom fields are not populated.


Any help would be appreciated.

1 answer

1 accepted

2 votes
Answer accepted

@Jacques B -

Here is a better way, when you export the result set, if you choose Export HTML report (current fields) format instead of Export Excel CSV, then the parent key will be retained in the summary column.

You can then open the exported HTML file using Excel and save the file as xlsx if needed.  No need to create custom fields as you suggested as an alternative.


Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Suggest an answer

Log in or Sign up to answer
Site Admin

Atlassian Community Events