Table Transformer - List Epics and Issue Story when Epics have identical summary texts

Question

Hello,

I have a project with Epics with Stories that are linked as "Issues in epic".
The summary of the Epics can have an identical names in my project.
This turns out as a big problem in Jira, because the Story 'Epic Link' is not a key or anything unique, it is the summary text.

In Table Transformer I have 2 tables with the epics and with the stories.

Now I want to join them in one table.
I found no way to get to the "Issues in epic" information 
and as said before the Epic Link of a Story links all Epics with that name but not the one parent Epic.

How I do this?
Thank you

Daniel Berežnoi · Answer

Hi Matthias,

Could you please open a support request with us in our support portal?

I may need to review some screenshots that might contain sensitive data to get a better understanding of the use case, so it would be safer to handle that in a more secure environment.

Let me know what you decide.

Daniel

Matthias Mödinger · Answer

Hello Daniel, thanks for looking into my problem.

Issues in Epic are listed in the epic like this:

below with keys and text.
But in JQL I get only these columns if I search for epic

There is no issues in epic. Links are giving me the "Issue Links" of the Epic.
So, I have no handle to this information.

Daniel Berežnoi · Answer

Hi Matthias,

This is Daniel from the Stiltsoft team, the creators of Table Filter, Charts, and Spreadsheets.

Does the Issues in Epic column contain story summaries or issue keys?

If the column contains issue keys, then you can use a modified query from our documentation to split the issue keys in the Issues in Epic column into separate rows. Then, you can JOIN the tables together based on the issue keys.

Let me know if this helps.

Daniel