CRM – Page 83 – Nishant Rana's Weblog

Using Relationship and RelationshipQueryCollection class to retrieve n to n relationship details in CRM.

Suppose we need to query a n:n relationship and get details of both the entity records involved.

For this we can make use of Relationship and RelationshipQueryCollection class,

Suppose I have an entity named A and it has n to n relationship with B Entity.

This I how we can get the details all the A records associated with a particular entity B record.

i.e. Name of all the A records associated with a particular B entity record along with the name of the B entity record.

</pre>
private void GetManytoManyRelationShipDetails(IOrganizationService _service, Guid entityBGuid)
 {
 // get offences records' name
 QueryExpression query = new QueryExpression("EntityA");
 ColumnSet cols = new ColumnSet();
 cols.AddColumn("EntityANameToBeRetreived");
 query.ColumnSet = cols;

// Relationship Name
 Relationship relationship = new Relationship("EntityA_EntityBRelationshipName");
 RelationshipQueryCollection relationshipColl = new RelationshipQueryCollection();
 relationshipColl.Add(relationship, query);

// get the legal issue record's name
 RetrieveRequest request = new RetrieveRequest();
 request.RelatedEntitiesQuery = relationshipColl;
 request.Target = new EntityReference("EntityB", entityBGuid);
 request.ColumnSet = new ColumnSet("EntityBNameToBeRetreived");
 RetrieveResponse response = (RetrieveResponse)_service.Execute(request);

string entityAName = string.Empty;

foreach (Entity entity in response.Entity.RelatedEntities[relationship].Entities)
 {
 entityAName += entity.Attributes["EntityAName"].ToString();
 }
 }

Hope it helps.

Fixed – Grid can not be used in this (‘quirks’) model in jqGrid

We got the above error in an HTML Web Resource which was using jqGrid. The page was working fine in IE 10 browser only in IE 8 we got that error.

The solution was to use the following meta tag inside the HEAD tag of the html page.

More details on this meta tag

http://stackoverflow.com/questions/6771258/whats-the-difference-if-meta-http-equiv-x-ua-compatible-content-ie-edge-e

Hope it helps.

Sample Code: OData Synchronous Call in CRM 2011

Just sharing the sample code to make synchronous OData call in CRM 2011.


var oDataRequestUrl = http://server/orgname/xrmservices/2011/OrganizationData.svc/ContactSet?$select=FullName

var result = syncODataCall(oDataRequestUrl);

// function to make synchronous oData call
 function syncODataCall(odataSelect) {
 var request = new XMLHttpRequest();
 request.open("GET", odataSelect, false);
 request.setRequestHeader("Accept", "application/json");
 request.setRequestHeader("Content-Type", "application/json; charset=utf-8");
 request.send();
 var objJQuery = jQuery.parseJSON(request.responseText);
 return objJQuery.d
 }

Check for following methods to parse the result returned

ProcessReturnedEntities(data.d.results)
ProcessReturnedEntity(data.d)

http://crmscape.blogspot.in/2011/03/crm-2011-odata-json-and-crm-forms.html

Hope it helps !

How to – Get OptionSet Label using FormattedValues property of Entity in Plugin in CRM

The easiest way to get the Label for the option set in plugin is using the FormattedValues property of the Entity.

The Post Create plugin on Contact record getting the label for the address type field.

if (context.InputParameters.Contains(“Target”) && context.InputParameters[“Target”] is Entity){

// Obtain the target entity from the input parmameters.

Entity entity = (Entity) context.InputParameters[“Target”];

if(entity.Contains(“address1_addresstypecode”)){

string addressTypeCodeLabel = entity.FormattedValues[“address1_addresstypecode”];

entity.Attributes[“address1_city”] = addressTypeCodeLabel;

service.Update(entity);}

}

http://community.dynamics.com/crm/b/crmmitchmilam/archive/2013/04/18/crm-sdk-nugget-entity-formattedvalues-property.aspx

Hope it helps.

REVIEW: Microsoft Dynamics CRM 2011 Scripting Cookbook

I recently received the e-book of Microsoft Dynamics CRM 2011 Scripting Cookbook (Packt Publishing by Nicolae Tarla) from the publisher for review.

The book has over 50 recipes divided in 10 chapters. It starts with basics of JavaScript in context of CRM and then goes into details of implementing validation, events handling, error handling, debugging etc. It also covers advanced topics like UI manipulation, using open source JavaScript libraries and framework and integration with Facebook, twitter etc. The book will be enjoyable and informative read for both the readers new as well as advanced.

Most of the recipes are nicely divided into following different sections

Getting Ready ( talks about what we need to implement the recipe)
How to do it ( step by step instructions on implementing it)
How it works ( this section goes into detail of the recipe)
There’s more… ( some additional information )
See Also ( references for further reading)

The book and all the recipes are so properly organized that it makes it very easy for the readers to understand and implement it, and also make reading the book a wonderful experience. A must read for everyone who loves working in Microsoft Dynamics CRM 2011.

We can get the book here

http://www.packtpub.com/microsoft-dynamics-crm-2011-scripting-cookbook/book