How to query ‘Value’ of a picklist rather than the ‘API NAME’, using SOQL?

I am using SOQL to query the opportunity. When I use the query,

SELECT CUSTOM_PICK_LIST_COL__C FROM OPPORTUNITY

I am getting the values under the API Name of the picklist items. How to get the value from the Values of the picklist?
enter image description here

Answer

You can use toLabel() to convert the picklist api name to a label:

SELECT toLabel(CUSTOM_PICK_LIST_COL__C) FROM OPPORTUNITY

Attribution
Source : Link , Question Author : Kannan Ramamoorthy , Answer Author : battery.cord

Leave a Comment