Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Issue with Script Include function call

Rose17
Tera Contributor

Hi All,

Requirement is based on change of assigned to, I need to display count of incidents assigned to the selected assigned to.

I had used onChange client script and Script include, but I am getting null value.

When I tried to debug using script debugger, logs, the function written inside script include is not getting executed.

I have provide admin role for the execute ACL for the script include, also it is client callable.

Below is the code-

Client script-

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '') {
        return;
    }
    //Type appropriate comment here, and begin script below

    var sc = new GlideAjax('getIncidentCount');
    sc.addParam('sysparm_func', 'getCount');
    sc.addParam('sysparm_value', g_form.getValue('assigned_to'));
    sc.getXML(getResponse);

    function getResponse(response) {
        var name = response.responseXML.documentElement.getAttribute('answer');
        g_form.addInfoMessage(name);
    }
}
 
Script include-
var getIncidentCount = Class.create();
getIncidentCount.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getCount: function()
    {
        var count;
        gs.log('inside SI');
        var assign= this.getParamater('sysparm_value');
        var user= new GlideAggregate('incident');
        user.addQuery('assigned_to',assign);
        user.addAggregate('COUNT','assigned_to');
        user.groupBy('assigned_to');
        user.query();
        while(user.next())
        {
            gs.log('inside SI if');
            count= user.getAggregate('COUNT','assigned_to');
            gs.log("inc count is "+count);  
        }
        return count;
    },
    type: 'getIncidentCount'
});
Could someone help me resolve this issue?
@Ankur Bawiskar Your help is highly appreciated.
 
Thanks in advance.

 

5 REPLIES 5

Rose17
Tera Contributor

It is working now. But when I try to display the message in the client script using- 

g_form.addInfoMessage("User " +g_form.getDisplayValue('assigned_to')+ " has " +count+ " assigned incidents");
It is showing the message on the form in this way- User INC0000055 has 9 assigned incidents.
Instead of assigned to name, it is showing incident number.