Stuck building table with issues list and their linked epics

Krzysztof Achinger

This will be a generic question because I am not even sure how to start. My goal is to build a table with issues and their corresponding Epic Names if the issue is linked to an epic.

I found that some data lives in Jira Issue Field table where I can find Epic Name and Epic Link in the Name column and some values in Value column, however Epic Link corresponding values are some numbers and I am not sure how to make a connection between those numbers and epic names to be displayed in a table.

Example

I have issue ABC-123 that has Epic Link to an epic XYZ-321 with an Epic Name "Test". I want a table that displays following columns and corresponding values:

| Issue Key | Linked Epic Name |
| ABC-123  | Test                        |

Matthew Lempitsky

So I started looking at this, and I believe I have come up with a solution. It looks like the "value" for the Issue Link field will be the "Issue Ref" value of the Issue. I have created what I hope is what you're after:

Let me know if you have any questions or concerns with this approach.