Java to set lookup value to related entity field...which is also a lookup

• Monday, May 14, 2012 12:14 PM

   

   
  

  0

  Hi

  I am trying to use Java Script to populate a lookupvalue with the value of a related entity's lookup field.
  

  The Java Script is On Save of entity3.
  Entity3 is related to entity2.
  And entity2 is related to entity1.
  Entity3 also has a relationship to entity1...which would be the same entity as which entity2 has a relationship with.
  I am trying to set this relationship, between entity3 and entity1

  When entity3 is saved (with a relationship to entity2 in place), I want to set it's relationship with entity1 to equal entity2's relationship with entity1

  I hope that made sense...below my code...but I can't seem to get e3 to e1 set.

  //Prepare variables for a entity3 to retrieve.
  var lookupItem = new Array;
  
  // Get the lookup for the ‘’ attribute on entity2
  lookupItem = crmForm.all.new_entity2id.DataValue;
  
  var entity2id = lookupItem[0].id;
  
  var authenticationHeader = GenerateAuthenticationHeader();
  
  //Prepare the SOAP message.
  var xml = "<?xml version='1.0' encoding='utf-8'?>"+ 
  "<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'>"+ 
  authenticationHeader+ 
  "<soap:Body>"+ 
  "<Retrieve xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+ 
  "<entityName>new_entity2</entityName>"+ 
  "<id>"+entity2id+"</id>"+ 
  "<columnSet xmlns:q1='http://schemas.microsoft.com/crm/2006/Query' xsi:type='q1:ColumnSet'>"+ 
  "<q1:Attributes>"+ 
  "<q1:Attribute>new_somefield1</q1:Attribute>"+ 
  "<q1:Attribute>new_somefield2</q1:Attribute>"+ 
  "<q1:Attribute>new_entity3id</q1:Attribute>"+ 
  "</q1:Attributes>"+ 
  "</columnSet>"+ 
  "</Retrieve>"+ 
  "</soap:Body>"+ 
  "</soap:Envelope>";
  //Prepare the xmlHttpObject and send the request.
  var xHReq = new ActiveXObject("Msxml2.XMLHTTP");
  xHReq.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
  xHReq.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/Retrieve");
  xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
  xHReq.setRequestHeader("Content-Length", xml.length);
  xHReq.send(xml);
  //Capture the result.
  var resultXml = xHReq.responseXML;
  
  //Check for errors.
  var errorCount = resultXml.selectNodes('//error').length;
  if (errorCount != 0)
  {
  var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
  alert(msg);
  }
  //Display the retrieved value.
  else
  {
  
  var someField1 = parseFloat(resultXml.selectSingleNode("//q1:new_somefield1").nodeTypedValue);
  crmForm.all.new_myField1.DataValue = someField1;
  crmForm.all.new_arrearbalance.ForceSubmit = true;
  
  var someField2 = parseFloat(resultXml.selectSingleNode("//q1:new_somefield2").nodeTypedValue);
  crmForm.all.new_myField2.DataValue =someField2;
  crmForm.all.new_myField2.ForceSubmit = true;
  
  var entity3 = parseFloat(resultXml.selectSingleNode("//q1:new_entity3id").nodeTypedValue);
  crmForm.all.new_entity3id.DataValue = entity3;
  crmForm.all.new_entity3id.ForceSubmit = true;
  }
  

  
  
  • Reply
  • Quote