function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AlexCRMmanagerAlexCRMmanager 

Getting child records from relationship query in an S-control

I'm executing the following query in an S-control:

Select w.Id,(Select Id From WOAssign__r) From WorkOrder__c w Where w.ID = '{!WOAssign__c.Work_OrderId__c}'

How do I extract the "WOAssign_r" records into a JavaScript array? I can't figure it out.
cheenathcheenath
Here is a sample of relationship query. HTHs

Code:
<html>
<head>
<script src="/soap/ajax/9.0/connection.js"></script>
<script src="/js/dojo/0.4.1/dojo.js"></script>

<script>
  dojo.addOnLoad(init);

function init() {
  var callback = {
    onSuccess : displayResult,
    onFailure : displayError
  };
  sforce.connection.query("SELECT Id, Name, (SELECT Id, IsDeleted, CaseNumber FROM Cases) FROM Account LIMIT 20", callback);
}

function displayResult(result) {
  var it = new sforce.QueryResultIterator(result);
  var html = [];
  while(it.hasNext()) {
    var record = it.next();
    html.push("Id = " + record.Id + "<br>");
    html.push("Name = " + record.Name + "<br>");
    if (record.Cases) {
      displayCasesResult(new sforce.QueryResultIterator(record.Cases), html);
    }
    html.push("<hr>");
    html.push("<br>");
  }

  document.getElementById("output-div").innerHTML = html.join("");
}
function displayCasesResult(it, html) {
  while(it.hasNext()) {
    var record = it.next();
      html.push("Id = " + record.Id + "<br>");
      html.push("IsDeleted = " + record.IsDeleted + "<br>");
      html.push("CaseNumber = " + record.CaseNumber + "<br>");
  }
}

function displayError(error) {
  document.getElementById("output-div").innerHTML =
    "oops something went wrong ... " + error;
}
</script>


</head>
<body>

  <div id="output-div"></div>

</body>
</html>