Microsoft Dynamics CRM (Archived)

How to apply Dynamic Filter on Lookup Field using JavaScript in Dynamics 365?

(0) Share

Report

Posted on by AnkitSinghal

256

Hi All,

I want to apply Dynamic filter on Lookup Field using JavaScript in Dynamics 365.

I have tried below code but its not working in Dynamics 365 :

function filterlookup(){

if(Xrm.Page.getControl("name") != null && Xrm.Page.getControl("name") != undefined){
Xrm.Page.getControl("parentaccountid").addPreSearch(function ()){
var fetchQuery = "<filter type="and"><condition attribute="name" operator="like" value="A%" /></filter>"
Xrm.Page.getControl("parentaccountid").addCustomFilter(fetchQuery);
});
}

}

Please suggest any good solution.

Thank You.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report
Copy link

Link copied!

Refer this:

www.inogic.com/.../apply-custom-filter-on-lookup-field-in-dynamic-crm-using-script

Was this reply helpful? Yes No
AnkitSinghal 256 on at

Like (0)

Report
Copy link

Link copied!

I have already tried to implement that code but its not working in Dynamics 365 Online.

Was this reply helpful? Yes No
mvilas02 356 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

What is the version of CRM online you are using ? 8.0 / 8.1 / 8.2 ? i think this code will only work in 8.1 and ahead.

I had the same problem

Regards,

Vilas

Was this reply helpful? Yes No
AnkitSinghal 256 on at

Like (0)

Report
Copy link

Link copied!

Hi Vilas,

I am using 8.2 version of dynamics CRM online.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report
Copy link

Link copied!

It seems like your code is fine. Are you getting any errors?

The following code works for me in version 8.2, maybe something I missed:

Xrm.Page.getControl("bgx_changerequesttypeid").addPreSearch(function () {

addActionTypeLookupFilter(recordTypeCode);

});

function addActionTypeLookupFilter(recordTypeCode)

{

var fetchXml = "<filter type='and'><condition attribute='bgx_recordtypecode' operator='eq' value='" + recordTypeCode + "' /></filter>";

Xrm.Page.getControl("bgx_changerequesttypeid").addCustomFilter(fetchXml);

}

Was this reply helpful? Yes No
Suggested answer

ashlega 34,477 on at

Like (0)

Report
Copy link

Link copied!

Hi,

it seems to be a syntax error. Try this:

function filterlookup(){

if(Xrm.Page.getControl("name") != null && Xrm.Page.getControl("name") != undefined){
Xrm.Page.getControl("parentaccountid").addPreSearch(function (){
var fetchQuery = "<filter type='and'><condition attribute='name' operator='like' value='A%' /></filter>";
Xrm.Page.getControl("parentaccountid").addCustomFilter(fetchQuery);
});
}
}

Was this reply helpful? Yes No
Gokul kansagara 65 on at

Like (0)

Report
Copy link

Link copied!

You Can try this, It's working properly.

if (typeof (OpportunityJS) == "undefined") { OpportunityJS = { __namespace: true }; }

OpportunityJS.Opportunity = {

OnOpportunityLoad: function (executionContext) {

var formContext = executionContext.getFormContext();

var fetchXML = "<filter type=\"and\">" +

"<condition attribute=\"address1_city\" operator=\"eq\" value=\"New York\" />" +

"</filter>";

formContext.getControl("parentaccountid").addCustomFilter(fetchXML);

},

OnAddPreSearchToAccountLoad: function (executionContext) {

var formContext = executionContext.getFormContext();

formContext.getControl("parentaccountid").addPreSearch(OpportunityJS.Opportunity.OnOpportunityLoad);

}

}

Was this reply helpful? Yes No