Hi Jose ,
You can use Query using fetch XML to get any attritube values of any related entity.
Eg : This example demostrate query to get the State of a CASE called from any other related entity
function GetCurrentCaseState(caseId) {
var retVal = "";
var sFetchXmlQuery = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'> <entity name='incident'><attribute name='statecode' /> <filter> <condition attribute='incidentid'
operator='eq' value='" + caseId + "' /> </filter></entity> </fetch>";
var fetchXmlResult = Fetch(sFetchXmlQuery);
if (fetchXmlResult != null) {
errorCount = fetchXmlResult.selectNodes('//error').length;
if (errorCount == 0) {
var regardingObject = fetchXmlResult.selectSingleNode("//statecode");
if (regardingObject != null) {
retVal = regardingObject.text;
}
}
}
return retVal;
}
// Fetch Function
function Fetch(xml) {
var Xml = "<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"
xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">"
Xml += GenerateAuthenticationHeader()
Xml += "<soap:Body>";
Xml += "<Fetch xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">";
Xml += "<fetchXml>";
Xml += FetchEncode(xml); // Microsoft _HtmlEncode function
Xml += "</fetchXml>";
Xml += "</Fetch>";
Xml += "</soap:Body>";
Xml += "</soap:Envelope>";
var XmlHttp = CreateXmlHttpObject(); // Microsot CreateXmlHttp function
XmlHttp.open("POST", "/mscrmservices/2007/crmservice.asmx", false); //Sync Request
XmlHttp.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
XmlHttp.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/Fetch");
XmlHttp.send(Xml);
var XmlDoc = new ActiveXObject("Msxml2.DOMDocument");
XmlDoc.async = false;
XmlDoc.resolveExternals = false;
XmlDoc.loadXML(XmlHttp.responseXML.text);
return XmlDoc;
}
This Fetch XML can be formed either using Advance find or using a tool such as one in stuntware site.
http://www.stunnware.com/crm2/
Hope this helps
Dk
--------------------------------------------------------------------------------
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
