How to include fields on a excel report of issues that are from the parent issue

[Jon]

hi, 

Iwas pulling a report of jira issue from excel (i could try via google sheets too if needed) and i can get any field that i want on the issue but i would like to pull  custom fields from the parent issue as well. is that possible? 

thanks 

jon

[Aron Gombas _Midori_]

In addition to the approaches suggested by @omar_blagui , you could create an Excel export template for the Better Excel Exporter app.

In the template, you can absolutely access the parent  work item, its field values and every other details.

The advantage here is that you will get the export with a single click, there is no need to post-process anything in Excel.

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

[Jon]

Hi Will this app Have the ability To send the report on a schedule?

thanks!

[omar_blagui]

Hello Jon,

When you pull Jira issues into Excel/Sheets, you only get the fields that belong to that specific issue, plus a parent reference(parent issue key) if it has one. So you can export the parent key, but not it customfields, as a direct column.

• Excel Post-processing: you can export two sets of data, the issue in a sheet and the parents in another one, and then use Excel's VLOOKUP function to bring the information via the parent key.
• The API Method: You need to write a script (in Python or any other language) that first retrieves all issues, then, for each issue with a parent ID, makes a second call to fetch the parent's details and custom fields, and finally writes the combined data to a CSV file.

Hope it will help you
Omar