Filtering Lookup

(0) Share

Report

Posted on by Community Member

Hi Guyz..

I am a beginner working in crm. I just want to filter look up using addpresearch function. In contact i have two fields state and city. I want to filter City based on the state. I have written the code but i am getting error as

unable to get addPresearch function.

function preFilterLookup() {

Xrm.Page.getControl("new_city").addPreSearch(function () {
addLookupFilter();
});

}

function addLookupFilter() {
//check if the city is not empty

var state = Xrm.Page.getAttribute("new_state").getValue();

//create a filter xml

var filter= "<filter type='and'>" +
"<condition attribute='new_state' operator='eq' value='" + state + "' />" +
"</filter>";
//add filter
Xrm.Page.getControl("new_city").addCustomFilter(filter);

}

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Mahendar Pal 45,095 on at

Like (0)

Report

Any reason why are you doing this through java script, when this can be done simply setting city lookup property to display city based on state ??

You can refer: rashans.wordpress.com/.../crm-2011-implementing-dependent-lookups

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ya i know even we can do this by this method also. But just for practice i want to do this way.

Was this reply helpful? Yes No
Suggested answer

Muhammad Salahuddin 470 on at

Like (0)

Report

"<condition attribute='new_state' operator='eq' value='" + state + "' />" +

"</filter>";

if "new_state" is lookup field, then.

Change above line of your code as:

"<condition attribute='new_state' operator='eq' value='" + state[0].id + "' />" +

"</filter>";

also register preFilterLookup() function on form load event.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Actually it is not going inside the function addLookupfilter

Was this reply helpful? Yes No
Mahendar Pal 45,095 on at

Like (0)

Report

Just to confirm, you are using CRM 2015 right ??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

ya. crm 2015 online.

Was this reply helpful? Yes No
Muhammad Salahuddin 470 on at

Like (0)

Report

Please write down the code you have written for below check:

//check if the city is not empty

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Are you trying to read the control from the Business Flow section??? or from Form area???

Best Regards

Shah

Was this reply helpful? Yes No
Mahendar Pal 45,095 on at

Like (0)

Report

Sharing screenshots of your field placement over forum, field name could help as well

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In the bottom you can see State and city. These are the lookup fields. Based on the state city should be filtered.

Was this reply helpful? Yes No