Hi,
I need to filter a form lookup by two other fields (not one which is well covered on the net) in the same time, to elaborate:
I have a Model that should be filtered by both the type and manufacturer fields on the same form so the user selects the manufacturer and type and the lookup populates the matching models.
I tried the preSearch by adding two conditions to the fetchXML but nothing is filtered, the whole list is shown!
Thank you for your support.
*This post is locked for comments
Hi Andrii,
It worked like charm, I should have added one filter tag with multiple conditions :(
Thank you for the great support :)
I see couple of potential issues. I fixed it. Try following code:
function onLoad(){
preFilterLookup();
}
function preFilterLookup() {
Xrm.Page.getControl("afg_assetmodel").addPreSearch(function () {
addLookupFilter();
});
}
function addLookupFilter() {
var manufacturerValObj = Xrm.Page.getAttribute("afg_manufacturer").getValue();
var assetSubTypeValObj = Xrm.Page.getAttribute("afg_assetsubtype").getValue();
if (manufacturerValObj != null || assetSubTypeValObj != null){
var resultfetch = "<filter type='and'>";
if (manufacturerValObj != null){
resultfetch += "<condition attribute='afg_manufacturer' operator='eq' value='" + manufacturerValObj[0].id + "' />";
}
if (assetSubTypeValObj != null){
resultfetch += "<condition attribute='afg_assetsubtype' operator='eq' value='" + assetSubTypeValObj[0].id + "' />";
}
resultfetch += "</filter>";
Xrm.Page.getControl("afg_assetmodel").addCustomFilter(resultfetch);
}
}
Hi Andrii,
Thank you for your support...
sure please find the code below:
function onLoad(){
preFilterLookup();
}
function preFilterLookup() {
Xrm.Page.getControl("afg_assetmodel").addPreSearch(function () {
addLookupFilter();
});
}
function addLookupFilter() {
var manufacturerValObj = Xrm.Page.getAttribute("afg_manufacturer").getValue();
var fetchXml1 = "<filter type='and'><condition attribute='afg_manufacturer' operator='eq' value='" + manufacturerValObj[0].id + "' /></filter>';
Xrm.Page.getControl("afg_assetmodel").addCustomFilter(fetchXml1);
var assetSubTypeValObj = Xrm.Page.getAttribute("afg_assetsubtype").getValue();
var fetchXml2 = "<filter type='and'><condition attribute='afg_assetsubtype' operator='eq' value='" + assetSubTypeValObj[0].id + "' /></filter>';
Xrm.Page.getControl("afg_assetmodel").addCustomFilter(fetchXml2);
}
}
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,430
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
