To populate list collector values based on another select box variable

[Koyel Guha]

Hi,

I am trying to populate the results in list collector variable based on the value selected from another variable.

I have variable A (selectbox) and variable B(list collector). When I select any option from variable A for eg. "x1" then variable B referencing a customized table having a field u_description which will filter u_description contains "read" keyword and u_description contains "x1". Based on the condition, it will display the one or multiple results from the table in the varible B.

I am using a script include and client script for this requirement and it is not working. Can somebody help on this.

Script Include : 

var FilterActiveDirectory = Class.create();

FilterActiveDirectory.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getFilteredSysIds: function() {

        var input = this.getParameter('sysparm_id');

        var info = [];

      var gr = new GlideRecord('u_active_directory_groups');

      gr.addEncodedQuery('u_descriptionLIKEread^u_descriptionLIKE'+ input);

    gr.query();

        while (gr.next()) {

        // info.push({

        //  "label": gr.u_query_name.toString(),

        //  "value": gr.u_query_name.toString()

        info.push({

         "label": gr.getValue('u_query_name'),

         "value": gr.getValue('u_query_name')

});

        }

    return info;

    //   return json.encode(info);

    },

     type: 'FilterActiveDirectory'

});

Client script : 

 function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading || newValue == '') {

        //g_form.clearValue('please_select_the_following');

     return;

    }

    var ga = new GlideAjax('FilterActiveDirectory');

    ga.addParam('sysparm_name', 'getFilteredSysIds');

    ga.addParam('sysparm_id', g_form.getValue('please_select_the_fileserver_where_the_shared_folder_is_located'));

    // ga.getXMLAnswer(info);

    // function info(answer) {

    // var msgObj = JSON.parse(answer);

    ga.getXMLAnswer(function(response) {

    var msgObj = JSON.parse(response);

g_form.clearOptions('please_select_the_following');

g_form.addOption('please_select_the_following', '', '--None--');

for (var i = 0; i < msgObj.length; i++) {

g_form.addOption('please_select_the_following', msgObj[i].value, msgObj[i].label);

}

//}

 //}

    });

}

[Ankur Bawiskar · Accepted solution]

@Koyel Guha 

you need to do 2 things which I mentioned in my 1st response to your question

1) advanced ref qualifier

a) why variable value will be random? You said it's a select box so it should have choices in it, you can use that.

You can use this, for x1 choice value you can have a query

javascript:var variableValue = current.variables.please_select_the_fileserver_where_the_shared_folder_is_located.toString() ; var query; if(variableValue == 'x1') query = 'u_descriptionLIKEread^u_descriptionLIKE' + variableValue; query; 

If you want the same filter for other drop down choices then do this generic

javascript:var variableValue = current.variables.please_select_the_fileserver_where_the_shared_folder_is_located.toString() ; var query = 'u_descriptionLIKEread^u_descriptionLIKE' + variableValue; query; 

2) variable attributes - add this

ref_qual_elements=please_select_the_fileserver_where_the_shared_folder_is_located 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Koyel Guha]

Hi Ankur,

Please check the screenshots I have provided above .  

Thanks