How to show reference field values based on selection of the record

[Gopal14]

Hi Team,

I am having 2 reference Variables.

1. Serial Number (alm_hardware table)

2. Hardware item (cmdb_hardware_product_model table)

In serial number if I select any record for that record we have model category. Let take I have selected 'Lenovo' for this record model category is "personal computer". 

In Hardware Item Variable, I need to show on "personal computer" model category only.

[Sai_Charan_K]

Hi @Gopal14 ,

Did you try checking what you are getting in console logs ? If so what did you get in it

[Gopal14]

Hi @Sai_Charan_K 

[Sai_Charan_K]

Hi @Gopal14 ,

Please find the scripts below:

Onchange Client script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    var ga = new GlideAjax('GetProductModelBySerial');
    ga.addParam('sysparm_name', 'getProductModel');
    ga.addParam('sysparm_serial_number', newValue);
	alert(newValue);
    ga.getXML(getProductModelParse);

    function getProductModelParse(response) {
        var answer = response.responseXML.documentElement.getAttribute("answer");
        //console.log("Hi "+answer);
        g_form.setValue('hardware_item', answer);

    }
}

Script Include: Please make sure this is client callable

var GetProductModelBySerial = Class.create();
GetProductModelBySerial.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getProductModel: function() {
        var serialNumber = this.getParameter('sysparm_serial_number');
        //gs.log("Hi" + serialNumber);
        var assetGR = new GlideRecord('alm_asset');
        assetGR.addQuery('sys_id', serialNumber);
        assetGR.query();
        if (assetGR.next()) {
            gs.log("Hi " + assetGR.model);
            return assetGR.model.sys_id;
        }
        return '';
    },
    type: 'GetProductModelBySerial'
});

PFA screenshots. 

Please mark my answer "Helpful" and "correct" if you feel that it has helped you in any way.

Thanks and Regards,
K. Sai Charan
Sr. ServiceNow Developer
Deloitte India

[Gopal14]

HI @Sai_Charan_K 

Updated in same way which you have given.

Not working, logs are not coming syslog_list table.

Script Include:

Client Script:

[Sai_Charan_K]

In client check variable name for hardware item