SQL Table Transformer to edit JIRA table

Katrina Atkinson September 18, 2023

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!

2 answers

1 accepted

4 votes
Answer accepted
Katerina Rudkovskaya _Stiltsoft_
Atlassian Partner
September 19, 2023

Hi @Katrina Atkinson,

Please check the example below:

Tue 2-1.png

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*

Tue 2-2.png

Dave Mathijs
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 12, 2023

Hi @Katrina Atkinson can you confirm whether the answer helped you? In that case, thanks to click the green 'Accept answer' button.

0 votes
Felix Linh
Contributor
September 18, 2023

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.

Sophia Kroening May 29, 2024

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?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events