2015年12月9日 星期三

CRM2011 How to get Options Set Value in DataBase?

CRM2011 How to get Options Set Value in DataBase?



StringMap table
SELECT AttributeValue, Value
FROM StringMap
WHERE ObjectTypeCode = 1 -- entity type code 1 = account
AND AttributeName = 'statecode' --fieldname


Entity Type Code
SELECT EntityId, Name, ObjectTypeCode
FROM [MetadataSchema].[Entity]
ORDER BY Name

沒有留言:

張貼留言