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 · Accepted solution]

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]

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

[Stiltsoft support]

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.