Export query results with multiple linked issues to excel

Question

Hi,

I was wandering If there is a way to export a query result with linked issue field so that a record repeats for each related issue. As an example, let's say that the query results is the following:

Key     |      linked issue

0001   | 1000, 1200, 1300

0002   | 2000, 2200

When exporting to excel, i would normally get the key column and n-columns for how many linked issue are displayed (in this scenario, 3 additional columns).

My aim is to obtain directly from the export the following in excel:

Key     |      linked issue

0001   | 1000

0001  | 1200

0001   | 1300

0002  | 2000 .....

I there a way to achieve this? Or maybe there is a way via jql?

Thanks a lot!

Hannes Obweger - JXL for Jira · Answer

Hi @Francesco Cattaneo

I don't think this is possible in "plain" Jira, so you may have to use some extra tooling for this, e.g. from the Atlassian Marketplace. I actually believe you could get pretty close with the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also supports configurable issue hierarchies - based on Jira's built-in parent/child relationships, and/or based on issue links.

With this, you can easily create a view like this, showing linked issues below their "parent" issue:

What you can do now is to work on your issues directly in JXL, trigger various operations in Jira, or export your issues to CSV or XSLX with just one click. The export won't look exactly as you described above, but reasonably close - so this may be worth a try.

Any questions just let me know,

Best,

Hannes

Aron Gombas _Midori_ · Answer

With our Better Excel Exporter app, you could do this.

There isn't a ready-built template for this exact layout, but it comes with templates for "selected fields plus repeated change history", "selected fields plus repeated worklogs", "selected fields plus repeated Tempo worklogs", etc., so there are several samples you could use to create your own template.

This, for example, repeats the columns A-G for each worklog, but the columns starting from H describe one worklog. Trivial: