Populate the domain values when a CI changes on incident form

Phanideepthi · Friday

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 · Monday

Hi @Phanideepthi ,

Your client script looks good but small issue in script include

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() + ""; // getDisplayValue you are using small D in display
            result.function1 = gr.u_business_function.getDisplayValue() + "";
        }
       gs.log("Check Return = " + JSON.stringify(result));
        return JSON.stringify(result);
    },

    type: 'GetBusinessDetails'
});

Also add alert in 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.function1);
        alert(obj.domain); // if you alert obj it will pass object object you can do JSON.stringify(obj) or dot walk
        g_form.setValue('u_business_domain', obj.domain);
        g_form.setValue('u_business_function', obj.function1);
    });
}

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

Thanks and Regards,

Sarthak

View solution in original post

Phanideepthi · yesterday

Hi @Sarthak Kashyap ,

I did updated the script and checked it did adding a new option on the dropdown and when trying to update troughing invalid insert error. Please help in this