英文:
Dynamics 365 - Issue with Jscript/fetchXML: linking entities for filtering a field
问题
我要创建的筛选器如下：我想要筛选位于我的表格（msdyn_customerasset）中的字段（uneeti_agreementinvoiceproduct）。筛选器必须满足以下条件：首先，合同的客户必须等于资产帐户。在我的fetchXML查询中，我将从我的表格（msdyn_agreementinvoiceproduct）中检索关联的合同表（msdyn_agreement）和字段（msdyn_serviceaccount）进行比较。其次，我只想显示已与合同资产相关联的产品。因此，我从我的表格（msdyn_customerasset）中检索我的产品字段，并从我的表格（msdyn_agreementinvoiceproduct）中提取（msdyn_product）。以下是我的检索查询，以及发生的错误。我不理解这个错误，因为指定的字段与指定的表格不相关。
function filterProductContratFS(context) {
var formContext = context.getFormContext();
var fieldRecipientCall = formContext.getAttribute("msdyn_account").getValue();
var fieldRecipientCall2 = formContext.getAttribute("msdyn_product").getValue();
if (fieldRecipientCall && fieldRecipientCall2) {
var accountId = fieldRecipientCall[0].id;
var productId = fieldRecipientCall2[0].id;
console.log(accountId);
console.log(productId);
var fetchXML =
"<fetch>" +
"<entity name='msdyn_agreementinvoiceproduct'>" +
"<link-entity name='msdyn_agreement' from='msdyn_agreementid' to='msdyn_agreement'>" +
"<filter>" +
"<condition attribute='msdyn_serviceaccount' operator='eq' value='" + accountId + "' uitype='account'/>" +
"</filter>" +
"</link-entity>" +
"<link-entity name='msdyn_customerasset' from='msdyn_customerassetid' to='msdyn_agreementinvoiceproductid'>" +
"<filter>" +
"<condition attribute='msdyn_product' operator='eq' value='" + productId + "' />" +
"</filter>" +
"</link-entity>" +
"</entity>" +
"</fetch>";
var agreementInvoiceProductControl = formContext.getControl("uneeti_agreementinvoiceproduct");
agreementInvoiceProductControl.addPreSearch(function () {
agreementInvoiceProductControl.addCustomFilter(fetchXML);
});
} else {
return;
}
}
有人能帮我解决这个问题吗？
英文:
The filter I want to create is as follows: I want to filter a field (uneeti_agreementinvoiceproduct) located in my table (msdyn_customerasset). The filter must meet the following conditions: firstly, the customer of the contract must be equal to the asset account. In my fetchXML query from my table (msdyn_agreementinvoiceproduct), I will retrieve the linked contract table (msdyn_agreement) and the field (msdyn_serviceaccount) for comparison. Secondly, I want to display only the products that are already associated with the contract asset. Therefore, I retrieve my product field from my table (msdyn_customerasset) and fetch the (msdyn_product) from my table (msdyn_agreementinvoiceproduct). Here is my retrieval query, along with the error that is occurring. I don't understand this error because the specified field is not associated with the indicated table.
function filterProductContratFS(context) {
var formContext = context.getFormContext();
var fieldRecipientCall = formContext.getAttribute("msdyn_account").getValue();
var fieldRecipientCall2 = formContext.getAttribute("msdyn_product").getValue();
if (fieldRecipientCall && fieldRecipientCall2) {
var accountId = fieldRecipientCall[0].id;
var productId = fieldRecipientCall2[0].id;
console.log(accountId);
console.log(productId);
var fetchXML =
"<fetch>" +
"<entity name='msdyn_agreementinvoiceproduct'>" +
"<link-entity name='msdyn_agreement' from='msdyn_agreementid' to='msdyn_agreement'>" +
"<filter>" +
"<condition attribute='msdyn_serviceaccount' operator='eq' value='" + accountId + "' uitype='account'/>" +
"</filter>" +
"</link-entity>" +
"<link-entity name='msdyn_customerasset' from='msdyn_customerassetid' to='msdyn_agreementinvoiceproductid'>" +
"<filter>" +
"<condition attribute='msdyn_product' operator='eq' value='" + productId + "' />" +
"</filter>" +
"</link-entity>" +
"</entity>" +
"</fetch>";
var agreementInvoiceProductControl = formContext.getControl("uneeti_agreementinvoiceproduct");
agreementInvoiceProductControl.addPreSearch(function () {
agreementInvoiceProductControl.addCustomFilter(fetchXML);
});
} else {
return;
}}
Can someone help me resolve this issue?
答案1
得分: 0
你应该仔细检查一下addCustomFilter函数的工作方式。它只接受过滤器本身。所以不包括实体、链接实体等等。我知道唯一可能让它工作的方法是在这里描述的 - https://missdynamicscrm.blogspot.com/2014/08/crm-2013-using-addcustomfilter-to-get-filtered-lookup-field-based-on-linked-entity.html
英文:
You should doublecheck on how addCustomFilter function works. It accepts only filter itself. So no entity, not link-entity and so on. The only way I know you might make it works is described here - https://missdynamicscrm.blogspot.com/2014/08/crm-2013-using-addcustomfilter-to-get-filtered-lookup-field-based-on-linked-entity.html
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论