Chart from Table and Table Transformer Row Error

Question

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

Stiltsoft support · Answer

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:

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

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.