Table transformation with different project languages

Schmidl82

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

Stiltsoft support

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', ...