Hello all,
I am using the Table Transformer macro in order to modify my JIRA table within confluence.
I would like to rename my columns. Currently it displays the field in JIRA I have pulled, however I would like the jira field to be pulled with a different column header.
So far, I have added an SQL to edit the width of the column:
SELECT *,
FORMATWIKI("{cell:width=700px; border-top:1px}", + 'Issues'+ "{cell}") AS 'Issues',
FORMATWIKI("{cell:width=300px; border-top:1px}", + 'Summary'+ "{cell}") AS 'Summary',
FORMATWIKI("{cell:width=200px; border-top:1px}", + 'Customer'+ "{cell}") AS 'Customer'
FROM T*
Can someone assist in how to add an SQL to Rename these columns (without duplicating the information on the table)? e.g., I would like the 'Issues' column to be named, 'dependencies'.
Thank you!
Hi @Katrina Atkinson,
Please check the example below:
SELECT
FORMATWIKI("{cell:width=700px; border-top:1px}", 'Issues', "{cell}") AS 'New Name for Issues',
FORMATWIKI("{cell:width=300px; border-top:1px}", 'Summary', "{cell}") AS 'New Name for Summary',
FORMATWIKI("{cell:width=200px; border-top:1px}", 'Customer', "{cell}") AS 'New Name for Customer'
FROM T*
Hi @Katrina Atkinson can you confirm whether the answer helped you? In that case, thanks to click the green 'Accept answer' button.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Katrina Atkinson nice to meet you and I would like to express my interesting in this issue.
Please modify code like below:
SELECT *,
FORMATWIKI("{cell:width=700px; border-top:1px}", + 'dependencies'+ "{cell}") AS 'dependencies',
FORMATWIKI("{cell:width=300px; border-top:1px}", + 'Summary'+ "{cell}") AS 'Summary',
FORMATWIKI("{cell:width=200px; border-top:1px}", + 'Customer'+ "{cell}") AS 'Customer'
FROM T*
Thank you,
Felix M.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I tried this and the result was that all the values in the column were replaced with this text: cell:width=700px; border-top:1px. Any idea why this might be?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.