我创建了一个fetchxml来过滤CRM中的合同查找字段。我希望能够在合同查找字段中看到多少条记录。如果只有一条记录，我希望能够自动填充该查找字段。
使用API函数进行了尝试，以便能够遍历fetchxml记录，但在返回计数时没有任何运气。还有另一种方法可以获取我需要的结果吗？
function buildCustomView() {
// Some GUID but only needs to be unique among the other available views for the lookup
var viewId = "{00000000-0000-0000-0000-000000000001}";
var viewDisplayName = "Contracts for This Account";
//Only need Contracts for the selected Worksite and buisness unit if filled in
var worksite = getFieldValue("hc_worksite");
if (!worksite) { return; }
if (!worksite[0]) { return; }
if (!worksite[0].id) { return; }
//check if buisness unit is availble and if it is can filter lookup further
var buisnessUnit = getFieldValue("hc_businessunit");
var condition;
if (buisnessUnit != null) {
condition = "<filter type='and'>" +
"<condition attribute='hc_businessunit' operator='eq' value='" + buisnessUnit[0].id + "' />" +
"</filter>";
///if take out the account name, contract lookup will still be filteredl
} else {
condition = "";
}
//Get all Contracts that pertain to the selected worksite
var fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true' >" +
"<entity name='contract'>" +
"<attribute name='title' />" +
"<attribute name='customerid' />" +
"<attribute name='contractid' />" +
"<attribute name='hc_contracttype' />" +
"<attribute name='hc_contractsubtype' />" +
"<attribute name='activeon' />" +
"<attribute name='hc_contractlevel' />" +
"<attribute name='expireson' />" +
"<attribute name='hc_contractaccount' />" +
"<attribute name='hc_contract' />" +
"<order attribute='title' descending='false' />" + condition +
"<link-entity name='hc_account_contract' from='contractid' to='contractid' visible='false' intersect='true'>" +
"<link-entity name='account' from='accountid' to='accountid' alias='ab'>" +
"<filter type='and'>" +
"<condition attribute='accountid' operator='eq' value='" + worksite[0].id + "' />" +
"</filter>" +
"</link-entity>" +
"</link-entity>" +
"</entity>" +
"</fetch>";
//Set up the whole view's UI
var layoutXml = "<grid name='resultset' object='1' jump='hc_contract' select='1' icon='1' preview='2'>" +
"<row name='result' id='contractid'>" +
"<cell name='title' width='300' />" +
"<cell name='hc_contractaccount' width='200' />" +
"<cell name='hc_contracttype' width='100' />" +
"<cell name='hc_contractsubtype' width='100' />" +
"<cell name='hc_contractlevel' width='100' />" +
"<cell name='activeon' width='100' />" +
"<cell name='expireson' width='100' />" +
"<cell name='customerid' width='150' />" +
"<cell name='hc_contract' width='100' />" +
"</row>" +
"</grid>";
try {
//Set the view
Xrm.Page.getControl("hc_contract").addCustomView(viewId, "contract", viewDisplayName, fetchXml, layoutXml, true);
} catch (e) {
Xrm.Utility.alertDialog("Error: " + e.message);
}
var count = 0;
//count results of fetch xml
SDK.WEBAPI.executeFetchSync("contract", fetchXml,
function (results) {
for (i=0;i<results.length; i++){
count++;
}
Xrm.Utility.alertDialog(count);
},
function (error) {
//Show error
alertDialog("Error: " + error.message);
});
}最佳答案
您可以使用count聚合属性对FetchXML查询返回的记录进行计数。请参见documentation here。
将aggregate='true'放在提取的第一行中：
<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true' aggregate='true'>
然后添加一个计数聚合属性：
<attribute name='contractid' alias='contract_count' aggregate='count' />
然后在您的
executeFetchSync成功回调中获取值：results.entities[0].contract_count;