function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Naveen JainNaveen Jain 

How to retrieve translated field values in SOQL query

Hi,

 

How can I retrieve translated field values in SOQL Query.

 

e.g. If I were to translated industry (multi-select picklist), status (picklist) in Account object using translation workbench so that each of the values have translated labels in German, French as well.

 

Few questtions.

 

1. How do I retrieve the translated values for the picklist values? Looks like it depends on the languages of the application from where the query is being fired. Can I specify the language in the query?

2. How can I specify the translated values in SOQL for each?

3. Does SOSQL indexes translated values.

 

Thanks,

 

-Naveen

Naveen JainNaveen Jain

Looks like one has to use toLabel() to get the translated values.

 

However this means that a given session can get either the default values or the translated values for their locale.

 

Is it possible to get all the translated values for a given selected picklist item using REST API?