Thursday, January 15, 2015

Finding the value of the state and status codes in CRM 2011

select 
    AttributeName, 
    AttributeValue,
    Value
from dbo.StringMap 
where
(dbo.StringMap.AttributeName = 'statuscode' 
or
dbo.StringMap.AttributeName = 'statecode')
and 
dbo.StringMap.ObjectTypeCode = 1





Will display the following values for the Account Entity ( ObjectTypeCode = 1 ):

AttributeName AttributeValue Value 
statecode    0      Active
 
statecode   1       Inactive
 
statuscode  1   Active
 
statuscode   2 Inactive

No comments:

Post a Comment