Picklist value translation

Question

I have am email body I'm generating in APEX and I want it to include the translated value of a picklist. How can I get the translated value in APEX?

Sergej Utko · Accepted Answer · 2013-11-04 15:08:03Z

10

You can use a SOQL function toLabel() to get translated picklist values:

SELECT toLabel(your_field__c) FROM YourObject__c

A client application can have results from a query returned that are translated into the user’s language, using toLabel()

Sergej Utko

22k11 gold badges58 silver badges88 bronze badges

answered Nov 4, 2013 at 14:43

ManSpan

1,37810 silver badges18 bronze badges

mind adding a documentation reference or explaining how this function works ?
– Samuel De Rycke
Nov 4, 2013 at 15:10
1

thanx @mast0r for adding the documentation link and for the edit :)
– ManSpan
Nov 4, 2013 at 15:18
2

Thanks, but this is not ideal for me, I have the records already (getting them from the trigger). I prefer not to query again. I hoped there is something like 'getTranslatedValue()' or something like quering the translated values themselves
– Dedo
Nov 4, 2013 at 15:35
How about using email templates ? then you don't need to worry about translations SForce does it for you
– ManSpan
Nov 4, 2013 at 15:52

Add a comment |

1 Answer 1