Category Archives: Helpers

SQL Security Roles information

Here is an SQL to retrieve all security roles privileges for all entities to help with comparing or to be used in an SSRS report SELECT FilteredRole.name as UserName, EntityView.PhysicalName, EntityView.OriginalLocalizedName as DisplayName, Privilege.Name as PrivilegeName, AccessLevel = CASE Privilege.AccessRight … Continue reading

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

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

SQL get attributes details of entities

The following SQL can be used to retrieve information and details about all attributes in an entity. SELECT  EntityView.Name AS EntityName, LocalizedLabelView_1.Label AS EntityDisplayName, AttributeView.Name AS AttributeName, LocalizedLabelView_2.Label AS AttributeDisplayName,AttributeTypes.Description as Type, AttributeTypes.XmlType,AttributeView.Length,AttributeView.MaxLength,AttributeView.AttributeRequiredLevelId,Accuracy,IsCustomEntity,IsMappable,EntityView.IsCustomizable,EntityView.IsRenameable,IsActivity FROM    LocalizedLabelView AS LocalizedLabelView_2 INNER JOIN       AttributeView … Continue reading

Posted in Helpers, SQL | Leave a comment

Javascript call to a WCF method

Suppose we have a WCF method with URL ‘http://myserver/myservice.svc’ and a method MyMethod which expectes a parameter para1. We can call this WCF method using XMLHTTP, by using the following code: var xmlHttp3 = new ActiveXObject(‘Microsoft.XMLHTTP’); xmlHttp3.open(‘get’, ‘http://myserver/myservice.svc//MyMethod?para1=’ + value, false); xmlHttp3.send(); Another method … Continue reading

Posted in Helpers, Javascript | 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