Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Chart from Table and Table Transformer Row Error

Kim Trask December 8, 2023

Hi - using datacenter Confluence and Jira; I am seeing a max row number error in "Table Transformer" preview.

Prior to navigating here, I had set my maximum issues count (to 6 - I am using a simple test case instead of my actual case) in my included Jira Issue Filter table. No avail.

I am trying to join several Jira columns to a Confluence table that holds color coding information for a Gantt chart (Chart from Table macro). Maybe this row error is my problem, maybe not.

This is the SQL code I am trying to use: 

SELECT T1.'Key', T1.'Summary', T1.'T',T1.'Target start',T1.'Target end'FROM T1
JOIN T2 ON T1.'Key' = T2.'Key';

For clarity, though it might be obvious, T1 is my Jira Filter table and T2 is a simple three column Confluence table. The preview does omit the test issue that does not appear in both tables.

Thank you,

~Kim

1 answer

1 vote
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 11, 2023

Hi @Kim Trask ,

Your SQL query is correct but it seems that you need to display some columns from the T2 table as well. In your example you list just T1 columns, so there is no any point in joining two tables.

Please check the example below:

Mon 8-1.png

SELECT T1.'Key',
T1.'Column 1',
T2.'Column 2'
FROM T1
JOIN T2 ON T1.'Key' = T2.'Key'

Mon 8-2.png

Here I join my two tables by the unique 'Key' column and display 'Column 1' from T1 and 'Column 2' from T2.

Maybe it will be better to move to our support portal that is confidential. There you'll be able to share your screenshots and we'll guide you through the case.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events