Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,408
Community Members
 
Community Events
165
Community Groups

SQL Query for Table Transformer when I have columns with the same name in separate tables

I have 2 table excerpts:

T1 - Platform Table generated by a Jira Filter which contains the following fields: 

Issue Type, Key, Parent Summary, Summary, Feature type, Dev Fix Version, NTL Fix Version, Status

T2 - Feature Table generated by a Jira Filter that is just a "parentsof" the Platform Table. There are multiple Platforms per Feature. The Feature Table contains the following fields:

Issue Type, Key, Summary, Epic Link

I am trying to create a table that will merge these 2 tables and give me all of the T1 columns w/ the T2 Key and Epic Link columns

If I use the following SQL, I get all of the Platforms and the Epic Link, but not the Key from the Feature Table: 

SELECT * FROM T1 OUTER JOIN T* ON T1.'Parent Summary' = T2.'Summary'

I thought it might be because I have a Key column in both tables. So, I tried the following:

SELECT 'Key' as 'PKey', 'Parent Summary', 'Summary', 'Feature Type', 'Dev Fix Version', 'NTL Fix Version', 'Status'  FROM T1 OUTER JOIN T* ON T1.'Parent Summary' = T2.'Summary'

But, this returns an error: "TypeError: Cannot read properties of undefined (reading 'Key')"

1 answer

1 accepted

Hello @Susan Granz,

Please try the following SQL query:

SELECT T1.*,T2.'Key' AS 'Feature Key', T2.'epic link'
FROM T1 OUTER JOIN T* ON T1.'Parent Summary' = T2.'Summary'

BR,
Katerina 

Thank you! That did the trick. Now...my plan was to wrap a pivot table around my transformed table so I can place the Feature Key and the Parent Summary as the rows and the platform summary (and key) in the columns. But, I'm getting an error when I try to wrap my transformed table in a pivot table:

Oops! We are sorry but the current complex table cannot be filtered.

Hi @Susan Granz,

Please raise a support ticket here with the page storage format attached.
We'll try to investigate the issue you've faced.

Thanks!

BR,
Katerina 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

903 views 11 26
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you