Pass values from "List Type" field from client script to script include

[Aaviii]

I have a requirement to pass value from onChange client script for list type field to script include. Am using the below code but getting undefined value.

Client Script:

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

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

        return;

    }

    var ga = new GlideAjax('Test');

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

    ga.addParam('sysparm_first_value', newValue);

    ga.getXML(callback);

    function callback(response) {

        var answer = response.responseXML.documentElement.getAttribute("answer");

        var sysIds = JSON.parse(answer);

        if (sysIds.length > 0) {

            var query = 'sys_idIN' + sysIds.join(',');

            g_form.setReferenceQualifier('u_1', query);

        } else {

            g_form.setReferenceQualifier('u_1', '');

        }

    };

}

Script Include:

var Test = Class.create();

Test.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

    getChoices: function() {

        var firstFieldValue = this.getParameter('sysparm_first_value');

        var result = [];

        var gr = new GlideRecord('sys_choice');

        gr.addQuery('sys_id', 'firstFieldValue');

        gr.query();

        if (gr.next()) {

            result_value = gr.getValue('value');

            var gm = new GlideRecord('sys_choice');

            gm.addQuery('dependent_value', result_value);

            gm.query();

            while (gm.next()) {

                result.push(gm.sys_id + '');

            }

            return "sys_idIN" + result;

        }

    },

    type: 'Test'

});

[Arun_Manoj]

Hi @Aaviii ,

You're querying the sys_choice table by sys_id, but sys_choice usually doesn't use sys_id directly as a reference from form selections. You may actually be wanting to get choices for a specific field, where the element, name, and value columns are more relevant.

If you're trying to pass the selected value from a choice list field and want to retrieve other dependent choices based on that value, you might do better using the value field, not sys_id.

---

✅Corrected Script Include:

var Test = Class.create();
Test.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
getChoices: function() {
var firstFieldValue = this.getParameter('sysparm_first_value');
var result = [];

// Assuming you're trying to use the 'value' field, not sys_id
var gm = new GlideRecord('sys_choice');
gm.addQuery('dependent_value', firstFieldValue);
gm.query();
while (gm.next()) {
result.push(gm.getValue('sys_id'));
}

return JSON.stringify(result);
},
type: 'Test'
});

---

Client Script (No Change Needed for Ajax Call):

Just make sure your newValue is the actual value of the selected choice, which is typically true for choice fields.

If the solution is correct, please give Helpful

thanks

Arun

[Ankur Bawiskar]

@Aaviii 

what's your requirement here?

are you trying to apply reference qualifier via g_form object?

share some details and screenshots.

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

[Aaviii]

Yes, I have 2 fields of list type. Based on selection in first field, I want dependent value in second field.

[shantanu_patel8]

Hi @Aaviii ,

As the type of field is list then you must be getting comma-separated list of sys_ids rather then just a single sys_id so you can use the following script:

Client Script:

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

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

        return;

    }

    var ga = new GlideAjax('Test');

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

    ga.addParam('sysparm_first_value', newValue);

    ga.getXML(callback);

    function callback(response) {

        var answer = response.responseXML.documentElement.getAttribute("answer");

        var sysIds = JSON.parse(answer);

        if (sysIds.length > 0) {

            var query = 'sys_idIN' + sysIds.join(',');

            g_form.setReferenceQualifier('u_1', query);

        } else {

            g_form.setReferenceQualifier('u_1', '');

        }

    };

}

Script Include:

var Test = Class.create();

Test.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

   

getChoices: function() {

var firstFieldValue = this.getParameter('sysparm_first_value');

var result = [];

var firstFieldValueArr = firstFieldValue.split(',');

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

var gr = new GlideRecord('sys_choice');

gr.addQuery('sys_id', firstFieldValueArr[i]);

gr.query();

while(gr.next()) {

result_value = gr.getDisplayValue('value');

var gm = new GlideRecord('sys_choice');

gm.addQuery('dependent_value', result_value);

gm.query();

while (gm.next()) {

 result.push(gm.sys_id +'');

}

}

}

return "sys_idIN" + result;

},

    type: 'Test'

});

Please mark the answer helpful and correct if it resolves the issue. Happy scripting 

-Shantanu