Dynamics CRM - 在 JS 中使用 QueryExpression

      在上一篇博客中，介紹了 QueryExpression 在 C# plugin 中的使用，本篇主要介紹一下 QueryExpression 在 JS 中的使用，代碼示例如下：

//注意：取guid時要把花括號去掉
var currentId = Xrm.Page.data.entity.getId().replace("{", "").replace("}", "");
var pledgeId = Xrm.Page.getAttribute("cus_pledge_no").getValue()[0].id.replace("{", "").replace("}", "");

var q = new Sdk.Query.QueryExpression("account");
q.setDistinct(true);
q.setColumnSet("cus_donor_no");

//添加主表條件
var queryFilter = new Sdk.Query.FilterExpression(Sdk.Query.LogicalOperator.And);
queryFilter.addCondition(new Sdk.Query.ConditionExpression("account", "cus_status", Sdk.Query.ConditionOperator.Equal, Sdk.Query.Ints([972050001])));
queryFilter.addCondition(new Sdk.Query.ConditionExpression("account", "accountid", Sdk.Query.ConditionOperator.NotEqual, Sdk.Query.Guids([currentId])));
q.setCriteria(queryFilter);

//綁定子表查詢
//note: this.LinkEntity = function (linkFromEntityName, linkToEntityName, linkFromAttributeName, linkToAttributeName, joinOperator, entityAlias)
var le = new Sdk.Query.LinkEntity("account", "contact", "accountid", "cus_account_no", Sdk.Query.JoinOperator.Inner, "temp");

//添加子表條件
var linkFilter = new Sdk.Query.FilterExpression(Sdk.Query.LogicalOperator.And);
linkFilter.addCondition(new Sdk.Query.ConditionExpression("contact", "cus_status", Sdk.Query.ConditionOperator.Equal, Sdk.Query.Ints([972050000])));
linkFilter.addCondition(new Sdk.Query.ConditionExpression("cus_pledgetobeterminated", "cus_pledge_no", Sdk.Query.ConditionOperator.Equal, Sdk.Query.Guids([pledgeId])));
le.setLinkCriteria(linkFilter);
//設置要查詢的子表字段
le.setColumns("cus_remark");
q.addLink(le);

//執行查詢
Sdk.Async.retrieveMultiple(q, function (cResult) 
{
    var aResult = cResult.getEntities().toArray();
    for (var _i = 0; _i < aResult.length; _i++) {
        try {
            var _e = aResult[_i];
            var oView = _e.view();
            //console.log(_e.getId());

            // Donor No.
            var sDonorNo = "";
            if (oView.attributes.hasOwnProperty('cus_donor_no'))
                sDonorNo = _e.getValue("cus_donor_no");                          
            } catch (err) {
            console.error(err);
            }
45         }
}