Tag Archives: OptionSet

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

Retrieve the text label for an OptionSet value

Here is the implementation I use for a method to get back the text/caption of an OptionSet item. private  string GetOptionsSetTextOnValue(IOrganizationService service, string entityName, string attributeName, intselectedValue) { RetrieveAttributeRequest retrieveAttributeRequest = new  RetrieveAttributeRequest { EntityLogicalName = entityName, LogicalName = attributeName, … Continue reading

Posted in CRM SDK, Helpers, Plugins, Uncategorized | Tagged , | Leave a comment