nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Table Transformer to edit JIRA table

Katrina Atkinson

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!

Accepted answers

Katerina Rudkovskaya _Stiltsoft_

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

All comments

Felix Linh

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.

Katerina Rudkovskaya _Stiltsoft_

Dave Mathijs

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

Sophia Kroening

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?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

filter

table

unknown-hosting-type