如何在microsoft dynamics中获取optionset文本

Question

function nearByCases(addr){
    var nearByCasesFetchXML = '<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">' +
        '<entity name="incident">' +
          '<attribute name="title"/>' +
          '<attribute name="ticketnumber"/>' +
          '<attribute name="createdon"/>' +
          '<attribute name="new_department"/>' +
          '<attribute name="new_casetype"/>' +
          '<attribute name="incidentid"/>' +
          '<attribute name="caseorigincode"/>' +
          '<order descending="false" attribute="title"/>' +
          '<filter type="and"><condition attribute="new_address" value="'+addr+'" operator="eq"/>' +
          '</filter>' +
        '</entity>' +
      '</fetch>';

    nearByCasesFetchXML = "?fetchXml=" + encodeURIComponent(nearByCasesFetchXML);
    var html = "";
    //var outputText = "Case\t\t\tCreated\n---------------------------------------------------\n";
    window.parent.Xrm.WebApi.retrieveMultipleRecords("incident", nearByCasesFetchXML).then(function success(result) {
      console.log(result.entities);
      if(result.entities.length <=0) {
        window.parent.Xrm.Utility.alertDialog("No results found.", null);
        return false;
      }
      else{
        for (var casecount = 0; casecount < result.entities.length; casecount++) {
         // outputText += result.entities[casecount].ticketnumber+ "\t\t" + result.entities[casecount].title + "\n";
          html += "<tr>";
          html += "<td>"+result.entities[casecount].title+"</td>";
          html += "<td>"+result.entities[casecount].ticketnumber+"</td>";
          html += "<td>"+result.entities[casecount].FormattedValues["new_department"].ToString()+"</td>";
          html += "<td>"+result.entities[casecount].new_casetype+"</td>";
          html += "</tr>";
          $("#nearbycases tbody").html(html);
        }
        return true;
      }
      //window.parent.Xrm.Utility.alertDialog(outputText, null);
    },function (error) {
      // Handle error conditions
      window.parent.Xrm.Utility.alertDialog(error.message, null);
    });

}

{
  "@odata.etag": "W/"1999118"" ,
  "createdon": "2018-12-13T08:30:34Z" ,
  "[e-mail]": "12/13/2018 2:30 AM" ,
  "incidentid": "dedfb05b-b1fe-e811-a977-000d3a33eb4e" ,
  "new_casetype": 1 ,
  "[e-mail]": "Abandoned Vehicles" ,
  "new_department": 1 ,
  "[e-mail]": "Parking Control" ,
  "ticketnumber": "CAS-01001-H2S7L9" ,
  "title": "case for sla 1",
}

Answer 1

formattedvalue条目是选项集值的文本。

您得到的响应包含文本，所以这只是一个引用它的问题。

您可以这样引用它们：

var results = JSON.parse(this.response);
for (var i = 0; i < results.value.length; i++) {
    var departmentCode = results.value[i]["new_department"];
    var departmentCodeText = results.value[i]["[e-mail]"];
}

html +="<td>"+result.entities[casecount].FormattedValues["new_department"].ToString()+"</td>";

html += "<td>"+result.entities[casecount]["[e-mail]"]+"</td>";