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; } } }

Table Transformer Macro - Select Column If Exists

Emily Berg_alwhtk

Hello!

I am trying to work through an internal issue that has some users seeing certain syntax, while others don't For example, when I pull in the "fixversion" column field, the column name appears (to me) as 'Fix Version(s)'. To others, the column name appears as 'Fix Version/s'.

While our IT department continues to investigate, I would like to propose a workaround - check to see if the column exists in the table. If it does, select it for the output - I would assume this would allow all users to use the same query, while outputting the syntax that is working with their configuration.

So, to recap, I would like to rename columns in my table transformer. And for one column I would like to use the "If Exists" query to check if it's there - and rename accordingly. Another option would be to choose the column based on the index rather than the name (if that's possible).

Thank you!

Emily

Accepted answers

Emily Berg_alwhtk

I found a solution, but please advise if you find something different!

IF EXISTS(SELECT T1.'Fix Version(s)' FROM T1)
SELECT
T1.'Fix Version(s)' AS 'TER Fix Versions'
FROM T1
ELSE
SELECT
T1.'Fix Version/s' AS 'TER Fix Versions',
FROM T1

All comments

Emily Berg_alwhtk

I found a solution, but please advise if you find something different!

IF EXISTS(SELECT T1.'Fix Version(s)' FROM T1)
SELECT
T1.'Fix Version(s)' AS 'TER Fix Versions'
FROM T1
ELSE
SELECT
T1.'Fix Version/s' AS 'TER Fix Versions',
FROM T1

Katerina Kovriga {Stiltsoft}

Hi @Emily Berg ,

Please check the version of the Table Filter and Charts for Confluence app - the current one is 7.7.4.

I suppose that the problem is in the browser language settings: some users have American English and some use British English. We had such requests from our customers in the past and improved the Jira Issues macro performance.

So, please, update the app and tell us if the issue is still present.

Katerina Kovriga {Stiltsoft}

And here is another more simple workaround for similar cases - please check this abstract.

But again we strongly recommend to update the app firstly.

Emily Berg_alwhtk

Hi @Katerina Kovriga _Stiltsoft_ ,

My IT department has stated our current version is 7.1.13 for the Table Filter and Charts for Confluence App. I have inquired about upgrading, but I believe they are hesitant until we can confirm it will not disrupt current production users.

Regarding the language settings, the user experiencing the problems did have English (United Kingdom) as their top preference. She changed it to English (US) and the issue resolved. I assume a more recent version of the app would allow the UK language to be selected?

Thank you for the insight, this is very helpful and eliminates the need to include the "COALESCE" workaround.

Emily

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server

table-transformer