How to get option set value of an entity from sql server. I have developed a windows application , in which i was getting option set from crm using impersonization. But now my requirement is to get the value from sql server using sql server credentials but not with crm credentials.
select
e.Name as EntityName,
e.ObjectTypeCode,
s.AttributeName,
s.AttributeValue,
s.Value,
s.DisplayOrder
from
StringMap s
inner join EntityLogicalView e on
s.ObjectTypeCode = e.ObjectTypeCode
where
e.Name = 'new_entityname'
and s.AttributeName = 'new_optionsetname'
Direct SQL access is obviously unsupported but if you need to grab the info anyway, you need to look at the StringMap
view. You can then filter by entity and attribute name as required.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With