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.

[Ankur Bawiskar]

@Koyel Guha 

you should use advanced ref qualifier

why are you adding option?

Your advanced ref qualifier for list collector should be like this

Ensure you give correct field name and correct choice value of select box to compare

javascript: var query; if(current.variables.variableAName == 'x1') query = 'u_descriptionLIKEread^u_descriptionLIKEx1'; query; 

Add this in variable attributes of list collector

ref_qual_elements=variableAName

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

[Ankur Bawiskar]

@Koyel Guha 

Hope you are doing good.

Did my reply answer your question?

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

[Koyel Guha]

Hi Ankur,

I tried but it is not working.

Thanks

[Ankur Bawiskar]

@Koyel Guha 

it should work provided you followed all the steps correct.

are you using correct variable name?

are you using correct value to compare from select box variable?

are you giving correct filter condition/query?

did you give variable attributes?