How to add a blank column to a JIRA Table fetched into Confluence

[Santhosh Kumar]

Hi All,

Good day

I'm pulling a JIRA table into Confluence and applying some Table Transformer Macro to suit my needs. 

Now I have a new requirement to add a blank column (appending to the JIRA table) that enables users to add their remarks in Confluence.

I'm trying to create a table with a single blank column and merge it with JIRA table. However, there is no primary key to perform this join.

Can you please advise on how to perform this? Please see that I expect the Blank Column to have the same number of rows as the dynamic JIRA table. 

Thanks in Advance. 

Regards,

Santhosh

[Stiltsoft support]

Hi @Santhosh Kumar ,

Please check the second part of this Community question for reference: https://community.atlassian.com/t5/Confluence-questions/Can-I-dynamically-populate-the-fields-of-a-table-based-on-values/qaq-p/1505810

The 'Key' column should be present in your manually created table (you manually insert the issue keys and lookup the macro generated and manually created tables by the 'Key' column).

[Stiltsoft support]

And what concerns the type of JOIN function for the query if your tables have different number of rows: please check this page https://www.javatpoint.com/mysql-left-join-vs-right-join

If your macro generated table is the first one, you'll need LEFT JOIN.