How to add a blank/empty column in a Table Transformer

Ramu
Contributor
November 10, 2024

Hi All,

I have a scenario where i'm fetching JIRA fields in a Table Transformer Table in Confluence .. so it appears/displays like a Table but once you get into EDIT mode, it shows the Table inside Table Transformer panel (not the manual Table view of rows and cols)..

 

Now, i want to add Columns manually (reason being.. the users who is visiting this page has to update notes etc ..in additional columns)

 

To my knowledge ..it is not possible it seems ..hence, reaching out here to see if any of you can help.

 

I have tried adding a column in the Table Transformer SQL as:

 

ALTER TABLE T1 ADD NOTES VARCHAR(255);

 

but this is not happening.

 

In Short,

 

 I'm taking 3 columns from Jira to confluence. In confluence I need to add a new column and edit the column and display those changes within confluence page itself.

1 answer

0 votes
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.
November 11, 2024

Hi @Ramu ,

If you are talking about the Table Transformer macro provided by our Table Filter, Charts & Spreadsheets for Confluence app, then you may use the following workaround:

  • Put two tables inside your Table Transformer macro: Jira Issues and manually created table
  • In the manually created table name one column as "Key" (identically to the "Key" column coming from the Jira Issues macro) and use other columns for additional data
  • Go to the Table Transformer macro and use the standard Look Up preset to join these two tables by the unique "Key" column
  • When you need to add some data for the specific issue, type in its Key in the second manually created table and leave comments in other columns
  • When the page is published, you'll see one big table with Jira Issues and additional columns coming from the manually created table

Hope this helps your case.

Ramu
Contributor
November 11, 2024

wow .. sounds like some solution .. this is what i wanted to hear .. some workaround ..some technique or outta box thought ..

 

let me try and definitely post the outcome here  :) ..

 

Cheers n Thanks

Like Stiltsoft support likes this
Ramu
Contributor
November 12, 2024

Dear @Stiltsoft support  -> This works like a shine .. Thank you so much 

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events