Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Table transformation with different project languages

Schmidl82 March 8, 2024

Hi everybody,

I'm sure you can help.

Problem:

I have users with different languages set in the user preferences (American English, German).

I perform a table transformation in Confluence based on a JIRA Filter result.

The column names differ, based on the set language.

Like Key/Schlüssel in German, Summary/Zusammenfassung in German, and so on.

It starts with the SQL query.

SELECT
T1.'Description' 
FROM T1

works fine, when the language ist set to English.

When set to German, the query stops, as the column does not exist. I get an error massage. The corresponding working SELECT would be

SELECT
T1.'Beschreibung' 
FROM T1

I'm pretty stuck.

What I need is:
- a query which is able to read out English and German Column Names, without stopping
- if its English, rename it to the German name

Thanks in advance,

Christian

1 answer

1 accepted

2 votes
Answer accepted
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.
March 11, 2024

Hi @Schmidl82 ,

Please check this Community question: https://community.atlassian.com/t5/Confluence-questions/Can-I-dynamically-populate-the-fields-of-a-table-based-on-values/qaq-p/1505810

Navigate to the comments from 03 Dec, 2020 regarding English/Danish languages and the COALESCE function, seems you have the same case.

SELECT COALESCE(T1.'Key', T1.'Nøgle') AS 'Key', ...

Schmidl82 March 11, 2024

perfect! so easy (if you know it) :)

Like Stiltsoft support likes this
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.
March 11, 2024

By the way, you didn't specify your hosting type - if you still have this issue, I assume you are on Data Center and use a rather old version of the Table Filter, Charts & Spreadsheets app.

The current version is 11.0.0 - please ask your Confluence administrator to check it and update if required. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events