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,

Thanks for your response.

I have added glide_list in the attributes.

I have tried below: 

What should be the value in place of x1 ? It will a random one from the variable. Do i need to store the select box variable value in a variable and use that ?

javascript&colon; var query; if(current.variables.please_select_the_fileserver_where_the_shared_folder_is_located == ? ) query = 'u_descriptionLIKEread^u_descriptionLIKE?'; query;

Thanks for your support.

[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,

I have implemented this and it is not working. showing all the values.

Thanks.

[Ankur Bawiskar · Accepted solution]

@Koyel Guha 

please update : in your ref qualifier.

Community converts : to &colon;

share the choices for your select box?

Also share if there are records matching in your table with that filter condition?

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

[Koyel Guha]

Hey Ankur,

It is working now after updating " : "  :).

can i use glide_list and bo_filter on variable attributes ? or not required ? if i use this will it be comma separated ?

Thank You So Much for your help and patience.