2015年12月9日 星期三

CRM2011 How to get Options Set Value in DataBase?

CRM2011 How to get Options Set Value in DataBase?



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


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

沒有留言:

張貼留言