join Epic and Story without unique Epic summary with Table-Transformer plugin

Question

Hello

I have this hierarchy of Epics and Story multiple times:

Epic
  - Epic Summary: Test Assignment
  - 1 linked child Story
     -summary: "Developer Task"

I have 2 Tables

type = Epic AND summary ~ "Test Assignment"
type = Story AND summary ~ "Test Assignment"

How do I join them with table transformer so that I get a list of all Epic-Story pairs?

Something like this does not work because summary is not unique.

SELECT T2.'Key' as 'Story Key', T1.* FROM T1 LEFT JOIN T2 on T1.'Summary' = T2.'Epic Link'

Danut M _StonikByte_ · Answer

Hi @Matthias Mödinger,

The functionality that you mention seems related to a Confluence plugin. So would be best to contact the plugin vendor as a first step.

If you don't manage to get this done in the way you want, you could search for alternative options such as other plugins from Atlassian Marketplace that can display the info you want. A good solution could be our Great Gadgets plugin for Confluence that offers some macros that can display the epics along with their stories.

By using its Work Breakdown Structure (WBS) macro you can display the issues from a JQL / filter by their hierarchy along with their status. In you case, you must configure it with a filter that returns the epics and the stories to be displayed and it will do the grouping for you.

Or, the Pivot Table & Pivot Chart macro offered by the same app configured similarly.

These macros uses only JQL/filters, no complicated queries or JOINs are necessary.

Danut

Tomislav Tobijas · Answer

Hey @Matthias Mödinger ,

Just as a note - if no one jumps in here to answer this question, you can always reach out directly to the app vendor (if you're using ConfiForms, here's the link); all vendors have "Support" tab on their app listing and can be reached via stated channels.

Vendors are usually quite responsive when it comes to their apps - whether for use case questions or technical issues.

Hope you get this resolved.

Cheers,
Tobi