Filter lookup based on option set error

0
30
Forum Post: Change the Filter On option on Opportunity Associated View for Account form


Hi All, i’m trying to filter lookup based on a option set, however i found a couple of JS codes in the net and neither one of them seems to be working, so i’m guessing i’m not doing something correct in the code:

Here is the structure:

Entity: Replacement (voss_replacement)

Fields: Component Type (voss_device_component_type) – global option set (Component Type – voss_component_type)

  

Entity: External repair (voss_externalrepair)

Fields: Replacement (voss_replacement_part) – Lookup, Component type (voss_repair_component_type) – global option set (Component Type – voss_component_type),

Here is the code:

function filter_Lookup_Fields()

{

if (Xrm.Page.getControl(‘voss_device_component_type’) != null)

{

Xrm.Page.getControl(‘voss_replacement_part’).addPreSearch(addFilter);

}

}

function addFilter() {

var problemcategoryoptionset ;

var fetchQuery;

try {

problemcategoryoptionset = Xrm.Page.getControl(‘voss_device_component_type’).getAttribute().getValue();

if (Xrm.Page.getControl(‘voss_device_component_type’) != null && Xrm.Page.getControl(‘voss_device_component_type’).getAttribute().getValue() != null) {

fetchQuery = “<filter type=’and’>” +

“<condition attribute=’statecode’ operator=’eq’ value=’0′ />” +

“<condition attribute=’voss_device_component_type’ operator=’eq’ value='” + problemcategoryoptionset  + “‘ />” +

“</filter>”;

//add custom filter

Xrm.Page.getControl(‘voss_replacement_part’).addCustomFilter(fetchQuery);

}

}

catch (e) {

Xrm.Utility.alertDialog(‘addFilter Error: ‘ + (e.description || e.message));

}

}

Any help is appreciated.

Thank you in advance!



Source link

Leave a reply

Please enter your comment!
Please enter your name here