Fetch the Option-set label and value

In a select query, if the field type is an option-set it only displays the Value and not the Label.
But sometimes you need the label instead of the Value in the result set.

To get the list of Values and Labels for an option-set just pass the entity name & the option-set field name:

SELECT AttributeValue,Value 
From StringMap s inner Join EntityLogicalView e
ON s.ObjectTypeCode = e.ObjectTypeCode
where e.Name = '<entityname>' and s.AttributeName = '<option-set field name>'


You can use this as a sub-query in you main SELECT query like this:

SELECT Value from StringMap s inner join EntityLogicalView e on s.ObjectTypeCode = e.ObjectTypeCode where e.Name = '<entityname>' and s.AttributeName = '<fieldname>'
AND AttributeValue = <recordvalue>