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
沒有留言:
張貼留言