How to export issue links ?

[Lucile Cornet]

Hi all,

I'm using Jira DC and I need to export issue links info for all bugs linked to a specific stories scope.

I have 4 Themes that I'm following to for reporting purposes. Our hierarchy is Theme > Initiative > Epic > Story. I need to export all bugs linked by a "is blocked by, relates to, etc" to the Stories below my 4 Themes.

Do anybody knows how I could filter this in my API export to excel ? Many thanks for the help :)

[Tim Perrault]

Hi @Lucile Cornet 

You could try something like below.

issuetype = Bugs AND issueLinkType in ("is blocked by","relates to")

[Lucile Cornet]

Hi Tim,

Thanks for your answer but actually the problem is that I only want to export bugs that are linked to stories that are above specific themes.

For example I have : 

- Theme 101 > Initiative 102 > Epic 103 > Story 104

- Theme 201 > Initiative 202 > Epic 203 > Story 204

- And so on

Then, I have :

- Bug 999 blocking Story 104

- Bug 888 relates to Story 104

- Bug 777 relates to Story 204

I'd like to know how to target and export those bugs (777, 888 and 999), knowing that I have 4 themes for 400 initiatives and many many Stories.

I previously used issuekey in childIssuesOf for searching all the Initiatives, Epic and Stories below my 4 Themes, so I was hoping there was a similar solution for Linked Issues :)

[Lucile Cornet]

Actually, If I understood correclty, what I need would be IssueFunction in LinkedIssuesOf(Subquery) from ScriptRunner ... 

Problem is I don't have admin rights and no possibility to have them. So I'm looking for ANY solution that don't include admin rights

[Aron Gombas _Midori_]

It is not clear what is the output spreadsheet layout you're looking for, but Better Excel Exporter can export to a matrix-like overview like this:

Or, as @Tim Perrault suggested, if you can write a JQL query that collects the issue you're looking for, then you can export those from Issue Navigator.

[Sebastian]

Hello @Aron Gombas _Midori_

Can you send me your template for above picture?

I can't find how to refer to the issue links.

Please, help me fast.

Kudos