Dynamics CRM - Filter sub-grid Inline Lookup (Add Existing Button)

需求：

      最近有個需求，需要對 sub-grid Add Existing Button [+] 的 Lookup 内容進行過濾，如下圖：

 

解決方案：

      sub-grid Inlie lookup 實際上也是一個普通的 lookup 控件，因此一樣可以支持 lookup 字段的 addPreSearch 和 addCustomFilter 方法，後面我們就通過 JavaScript 利用這兩個方法來實現我們所需的效果。

 

代碼實現：

function fnFilterReceiptInline() {
    //sub-grid name: grid_receipt_list
    //[add existing button]: [sub-grid name]_addImageButton
    var subgirdAddBtnId = "grid_receipt_list_addImageButton";
    var subgridAddBtn = document.getElementById(subgirdAddBtnId) || window.parent.document.getElementById(subgirdAddBtnId);//獲取[+]的dom元素
    if (subgridAddBtn == null) {
        setTimeout(fnFilterReceiptInline, 1000);
        return;
    }

    var getSubgridLookupAndAddFilter = function () {
        //lookup控件名: lookup_[sub-grid name]
        var subgridLookup = Xrm.Page.getControl("lookup_grid_receipt_list");//獲取lookup控件
        if (subgridLookup == null) {
            setTimeout(getSubgridLookupAndAddFilter, 200);
            return;
        }
        if (subgridLookup.customFilterAdded) {
            return;
        }

        //addPreSeach for lookup control
        subgridLookup.addPreSearch(function () {
            fnFilterHandler();
        });
        subgridLookup.customFilterAdded = true;
    };
    //給[+]添加一個click事件：點擊后對lookup控件進行 pre search
    subgridAddBtn.addEventListener("click", function () {
        setTimeout(getSubgridLookupAndAddFilter, 200);
    });
}

//利用fetch xml 對 lookup control 進行過濾篩選
function fnFilterHandler() {
    var subgridLookup = Xrm.Page.getControl("lookup_grid_receipt_list");

    var oId = null;
    var oName = null;
    var oAccount = Xrm.Page.getAttribute("cus_account_no").getValue();
    if (oAccount != null && oAccount[0] != null) {
        oId = oAccount[0].id.replace("{", "").replace("}", "");
        oName = oAccount[0].name;
    }

    var FilterXML = "<filter type='and'>"
                  + "<condition attribute='cus_account_no' operator='eq' uiname='" 
                  + oName + "' uitype='account' value='{" + oId + "}' />"
                  + "</filter>";
    if (oName != null && oId != null) {
        subgridLookup.addCustomFilter(FilterXML);
    }
}

      以上代碼的效果：當點擊 [+] 時，js 就會對 Inline-lookup 控件進行 PreSearch，達到所需的過濾效果。

      參考博客：https://bernado-nguyen-hoan.com/2017/01/06/apply-filtering-to-subgrids-inline-lookup-in-crm/