Author Archives: mrashwan

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

Javascript Common issues with CRM

Important random notes you need to be cautious about when developing client side script for CRM forms. Always make sure the URL of the page is not localhost (Should be the server name). If you have a script code into which there … Continue reading

Posted in Error, Javascript, Uncategorized | Tagged , , , , | Leave a comment

Sharepoint Error: Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa.

I have googled a lot about this and couldn’t find a specific clear explanation for the problem. But found a practical solution which is IISRESET or maybe restart the sharepoint server.

Posted in Error, Sharepoint, Uncategorized | Tagged , , | Leave a comment