How to change Choices in Catalog Item Variable based on logged-in user's language settings?

[Aki18]

I understand that Choice (sys_choice) table has the Language field to make the instance dynamically change the choices in accordance with the logged-in user's settings.

However, Question Choice (question_choice) for the Service Portal does not have the Language field... I really don't understand why we can't set the language for it.

Does anyone has a good idea to change Choices in Catalog Item Variable based on logged-in user's language settings?

Best Regards,

Aki

[AnubhavRitolia · Accepted solution]

Hi Aki,

Translation for question_choice table is stored 'sys_translated' table. You can create translation record for your choices in this table.

Please mark this as correct answer if it resolved, or mark this helpful if this help you to reach towards solution.

[Ankur Bawiskar]

Hi,

As mentioned by Anubhav you need to create entry into Translated Name / Fields table

Regards
Ankur

[Justin Donath]

Hi all, 

for at least Xanadu release, the provided solution does not work.

If you want to translate a Question Choice you are using in a Select Box Catalog Variable, 

you need to create a record in Translated Text [sys_translated_text] table:

    - Language: choose language for translation

    - Table Name: chooce "Question Choice [question_choice]" table

    - Field Name: choose "Text [text]" field

    - Document: choose the specific question_choice record for translation

    - Value: The translated value in the choosen language

You may need to perform a local cache clear (SN Utils: /cls) or cache.do in the filter navigator to see the changes.