+ Start a Discussion
r_boyd_848r_boyd_848 

Localization, Picklists and SOQL

I understand that the Translation Workbench allows for the values in a pick list to be converted to an other langauge. What is the impact on SOQL queries that use he value of a picklist in its WHERE clause

 

Will 

select name from account where type = 'prospect'

Still work if the picklist is localised to say German or does the SOQl statement need to be changed to

select name from account where type = 'aussicht'

 

Best Answer chosen by Admin (Salesforce Developers) 
cloudgofercloudgofer

No need to change SOQL , SOQL still refers to original value.

All Answers

cloudgofercloudgofer

No need to change SOQL , SOQL still refers to original value.

This was selected as the best answer
r_boyd_848r_boyd_848

Very very cool. Thanks for that