Seeing Jira Issue Link for specific Link Type

[larry joseph]

I would like to run a Jira query and get back an issue's linked issue of a specific link type.

Issue A is linked to the following with the associated link type

• Issue 1 with Link Type Is Built By
• Issue 2 with Link Type Blocks

I want to get a column in the query results that just has Issue 1 listed.  Currently the Linked Issues column has Issue-1, Issue-2.

Desired result set:

| Key      | Linked Issue |

| Issue A | Issue 1        |

Use case:  I'm using Stiltsoft table transformer.  I want to join into a single row issues with their linked Built By issue. This will allow me to pull fields from the parent issue and the linked issue into a single row for a report.  Since the Linked Issues column has multiple issues listed and there is no way to tell the link type I'm not seeing a way to join the data on the correct linked issue.

Table A: returns all the parent issues

Table B: returns all the child, linked issues

Join A to B on the Linked Issue (for the linked issue of type Is Built By)