Populate the domain values when a CI changes on incident form

[Phanideepthi]

Hi All,

We have two fields Business domain and Business function on the incident form as shown in the image. Now we are working on getting the values populated on the form when a CI is selected. We have written before insert business rule with the following script.

(function executeRule(current, previous /*null when async*/) {

var ubus = new GlideRecord('cmdb_ci_service_discovered');

    ubus.addQuery('sys_id',current.cmdb_ci);

    ubus.query();

    if (ubus.next()) {

        current.u_business_domain = ubus.u_business_domain;

        current.u_business_function = ubus.u_business_function;

        // gs.print(ubus.u_business_domain);

    }

})(current, previous);

Now the issue we are facing is the values are populating once the form is saved instead we need to show when a CI is selected. Any help on this is much helpfull.

Thanks in advance.

[Sarthak Kashyap]

Hi @Phanideepthi ,

Issue is you created Business Rule, BR will run when it got some trigger condition, as you mention before insert, but you want the value will auto populate when you select the field. 

So in this case please create On-Change Client script, table - Incident, field - CI Field and add below script

function onChange(control, oldValue, newValue) {

    if (!newValue) {
        g_form.clearValue('u_business_domain'); // Your field backend value
        g_form.clearValue('u_business_function'); //Your field backend value
        return;
    }

    var ga = new GlideAjax('GetBusinessDetails');
    ga.addParam('sysparm_name', 'getValues');
    ga.addParam('sysparm_ci', newValue); // new Value is your CI field value sysId 

    ga.getXML(function(response) {
        var answer = response.responseXML.documentElement.getAttribute("answer");
        var obj = JSON.parse(answer);

        g_form.setValue('u_business_domain', obj.domain);
        g_form.setValue('u_business_function', obj.function);
    });
}

Now Create Script Include - GlideAjax Checked and add below script 

var GetBusinessDetails = Class.create();
GetBusinessDetails.prototype = {
    initialize: function() {},

    getValues: function() {
        var ciSysId = this.getParameter("sysparm_ci");
        var result = {};
        var gr = new GlideRecord('cmdb_ci_service_discovered');
        if (gr.get(ciSysId)) {
            result.domain = gr.u_business_domain + "";
            result.function = gr.u_business_function + "";
        }
        return JSON.stringify(result);
    },

    type: 'GetBusinessDetails'
};

Let me know if you need more help!

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak

[Phanideepthi]

Hi @Sarthak Kashyap ,

Thanks for your reply. I am getting undefined value as shown in the image when using the above script.

Note: we do have dropdown values in business domain and function and need to be selected from there instead of creating new values.

[Sarthak Kashyap]

Hi @Phanideepthi ,

Try to add logs in your script include and add alert in your callback function in client script and check where you are getting the undefined or send me the script

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak

[Phanideepthi]

Here is the script and alert

var GetBusinessDetails = Class.create();

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

    getValues: function() {

        gs.log('function');

        var ciSysId = this.getParameter("sysparm_ci");

        var result = {};

        var gr = new GlideRecord('cmdb_ci');

        if (gr.get(ciSysId)) {

            result.domain = gr.u_business_domain.getdisplayValue() + "";

            result.function1 = gr.u_business_function + "";

        }

        return JSON.stringify(result);

    },

    type: 'GetBusinessDetails'

});

Client script

function onChange(control, oldValue, newValue) {

    if (!newValue) {

        g_form.clearValue('u_business_domain'); // Your field backend value

        g_form.clearValue('u_business_function'); //Your field backend value

        return;

    }

    var ga = new GlideAjax('GetBusinessDetails');

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

    ga.addParam('sysparm_ci', newValue); // new Value is your CI field value sysId

    ga.getXML(function(response) {

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

        var obj = JSON.parse(answer);

alert(obj);

        g_form.setValue('u_business_domain', obj.domain);

        g_form.setValue('u_business_function', obj.function1);

    });

}