Tag Archives: attribute

SQL get picklist details (CRM 4.0)

The following SQL can be used to retrieve information about picklists in CRM 4.0 SELECT  LocalizedLabelView_1.Label AS EntityDisplayName, EntityView.Name AS EntityName, LocalizedLabelView_2.Label AS AttributeDisplayName, AttributeView.Name AS AttributeName , StringMap.AttributeValue, StringMap.Value AS AttributeValueCaption, AttributeTypes.Description as Type,AttributeTypes.XmlType,AttributeView.Length,Accuracy,IsCustomEntity,IsMappable,EntityView.IsCustomizable,EntityView.IsRenameable,IsActivity,AttributeView.AttributeRequiredLevelId FROM    LocalizedLabelView AS LocalizedLabelView_2 INNER … Continue reading

Posted in Helpers, SQL | Tagged , , , , , | Leave a comment

SQL get optionset details

The followin SQL can be used to retrieve information about optionsets in all entitesSELECT  EntityView.Name AS EntityName, LocalizedLabelView_1.Label AS EntityDisplayName, AttributeView.Name AS AttributeName, LocalizedLabelView_2.Label AS AttributeDisplayName, Stringmap.Value,Stringmap.AttributeValue,StringMap.DisplayOrder, AttributeTypes.Description as Type, AttributeTypes.XmlType,AttributeView.Length,Accuracy,IsCustomEntity,IsMappable,EntityView.IsCustomizable,EntityView.IsRenameable,IsActivity FROM    LocalizedLabelView AS LocalizedLabelView_2 INNER JOIN       AttributeView ON LocalizedLabelView_2.ObjectId … Continue reading

Posted in Helpers, SQL | Tagged , , , , | Leave a comment