Month: May 2014

Retrieve related field value using oData Query


Sharing code which retrieves related record’s field data value (Connections) and parse the data based on relationship metadata type property.

function RetrieveConectionNames() {

if (Xrm.Page.ui.getFormType() != 1) {

var CurrentRecordID = Xrm.Page.data.entity.getId();

var PartnerGUID = CurrentRecordID.substring(1, 37);

var serverUrl = Xrm.Page.context.getClientUrl(); //JS Fix

var ODATA_ENDPOINT = “/xrmservices/2011/OrganizationData.svc”;

var ODATA_EntityCollection = “/ConnectionSet?$select=Record2Id,Record2RoleId,contact_connections2/EMailAddress1,systemuser_connections2/InternalEMailAddress&$expand=contact_connections2,systemuser_connections2”;

var ODATA_Filter1 = “&$filter=Record1Id/Id eq guid'” + PartnerGUID + “‘”;

var ODATA_Filter2 = ” and (Record2RoleId/Id eq guid’44F5CBE2-3B2F-E011-BBAB-00155DC94520′ or Record2RoleId/Id eq guid’04E4BA76-5D5F-E111-BF46-00155DC94520′ or Record2RoleId/Id eq guid’170AFFF8-3B2F-E011-BBAB-00155DC94520′ or Record2RoleId/Id eq guid’DA759615-93A2-E211-BBE9-002DD80B0CA0′ or Record2RoleId/Id eq guid’1EB23AA0-19BE-E311-9413-002DD80B0CA0’)”;

var ODATA_OrderBy = “&$orderby=Record2RoleId”;

var ODATA_Final_url = serverUrl + ODATA_ENDPOINT + ODATA_EntityCollection + ODATA_Filter1 + ODATA_Filter2 + ODATA_OrderBy;

//Calls the REST endpoint to retrieve data

$.ajax({

type: “GET”,

contentType: “application/json; charset=utf-8”,

datatype: “json”,

url: ODATA_Final_url,

beforeSend: function (XMLHttpRequest) {

XMLHttpRequest.setRequestHeader(“Accept”, “application/json”);

},

success: function (data, textStatus, XmlHttpRequest) {

var result = ”;

for (i = 0; i < data.d.results.length; i++) {

result += data.d.results[i].Record2RoleId.Name + ” – ” + data.d.results[i].Record2Id.Name + ” – “;

if (data.d.results[i].contact_connections2 != null) {

if (data.d.results[i].contact_connections2.__metadata.type == “Microsoft.Crm.Sdk.Data.Services.Contact”) {

result += data.d.results[i].contact_connections2.EMailAddress1 + “\r\n”;;

}
}

if (data.d.results[i].systemuser_connections2 != null) {

if (data.d.results[i].systemuser_connections2.__metadata.type == “Microsoft.Crm.Sdk.Data.Services.SystemUser”) {

result += data.d.results[i].systemuser_connections2.InternalEMailAddress + “\r\n”;;

}
}
}

Xrm.Page.getAttribute(“new_oabnames”).setValue(result);

Xrm.Page.data.entity.save();

},

error: function (XmlHttpRequest, textStatus, errorThrown) {

alert(‘Error: ‘ + ODATA_Final_url);

}

});

}

}

Note: Notice the double underscore(__) before metadata i.e __metadata.type

Hope this help you.

Check open activity related case using oData query


Sharing below code which returns some value using oData query. This function will check if there is any open activity related to Incident entity.

function CheckOpenActivity() {

var Id = parent.Xrm.Page.data.entity.getId();

var IncidentId = Id.substring(1, 37);

//Retrieve dynamically the organization’s server url

var serverUrl = document.location.protocol + “//” + document.location.host + “/” + Xrm.Page.context.getOrgUniqueName();

var ODATA_ENDPOINT = “/xrmservices/2011/OrganizationData.svc”;

var ODATA_EntityCollection = “/IncidentSet?$select=IncidentId,Incident_ActivityPointers/ActivityId,Incident_ActivityPointers/StateCode&$expand=Incident_ActivityPointers”;

var ODATA_Filter1 = “&$filter=IncidentId eq guid'” + IncidentId + “‘”;

var oDataRequestUrl = serverUrl + ODATA_ENDPOINT + ODATA_EntityCollection + ODATA_Filter1;

var result = syncODataCall(oDataRequestUrl);

var isOpenActivity = ProcessReturnedEntities(result);

if (isOpenActivity)
alert(‘The Case has open Activity’);
else
alert(‘The Case has not any open Activity’);

}

// 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

}

function ProcessReturnedEntities(d) {

var hasRelated = false;

if (d.results[0] != null) {

var activities = d.results[0].Incident_ActivityPointers;

if (activities != null) {

if (activities.results.length > 0) {

$.each(activities.results, function (index) {

if (activities.results[index].StateCode.Value == ‘0’) {

hasRelated = true;
return hasRelated;

}
});

} else {
hasRelated = false;
return hasRelated;
}

} else {
hasRelated = false;
return hasRelated;
}
}
return hasRelated;
}

 

Hope this help you.

%d bloggers like this: