Filter lookup based on option set error

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)





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  + “‘ />” +


//add custom filter




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