Get values from "sys_user" using script Include

[F_bio Santos]

Hi everyone, Im trying to make a client script, that will change the fields "email" and "country" when the "assigned_to" changes.

Im doing a Client Script "OnChange()", calling a script include, I will leave the code that Im using bellow.

Script Include:

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

    getUserInfo: function(userId) {
        var gr = new GlideRecord('sys_user');
        gr.addQuery('sys_id', userId);
        gr.query();

        if (gr.next()) {
            var results = {
                "country": gr.location.country.getDisplayValue(),
                "email": gr.getValue('email')
            };
        }
        return JSON.stringify(results);
    },

    type: 'UserInfo'
};

Client Script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue === '') {
        return;
    }

    g_form.addInfoMessage('Assigned to changed. New Value: ' + newValue);

    var userSysId = newValue;

    if (userSysId) {
        var ga = new GlideAjax('UserInfo');
        ga.addParam('sysparm_name', 'getUserInfo');
        ga.addParam('userId', userSysId);
        ga.getXMLAnswer(response);
    }

    g_form.addInfoMessage(response + 'TesteResponse');

    function response(answer) {
        if (answer) {
            g_form.addInfoMessage('Running the IF');
            var returneddata = JSON.parse(answer);
            g_form.setValue("u_assigned_to_country", returneddata.country);
            g_form.setValue("u_assigned_to_email", returneddata.email);
        }
    }
}

When I change the assigned_to nothing happens, and it is not running the "if(answer)"
 

[Badrinarayan]

Hi @F_bio Santos , 

I have Made few Modifications to your code 

In the Client Script :

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue === '') {
        return;
    }
    g_form.addInfoMessage('Assigned to changed. New Value: ' + newValue);
    var userSysId = newValue;
    var ga = new GlideAjax('UserInfo');
    ga.addParam('sysparm_name', 'getUserInfo');
    ga.addParam('sysparm_userId', userSysId);
    ga.getXMLAnswer(function(answer) {
        if (answer) {
                g_form.addInfoMessage('Running the IF');
                var returneddata = JSON.parse(answer);
                g_form.setValue("short_description", returneddata.country);
                g_form.setValue("description", returneddata.email);
        } else {
            g_form.addErrorMessage('No data returned for the selected user.');
        }
    });
}

In the Script Includes Part :

var UserInfo = Class.create();
UserInfo.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    getUserInfo: function(userId) {
        var ab = this.getParameter('sysparm_userId');
        var gr = new GlideRecord('sys_user');
        gr.get(ab);
        gr.query();
		if (gr.next()) {
            var results = {
                "country": gr.location.country.getDisplayValue(),
                "email": gr.getValue('email')
            };
        }
        return JSON.stringify(results);
    },
    type: 'UserInfo'
});

 

Output:

Values are populating in the short description and description Fields , please edit the fields which are need to be populated

Mark as Helpful , if this Answer works
thanks Regards
Badri

[Servicenow34 · Accepted solution]

Hey @F_bio Santos 

Kindly find below code. This is working for me.

Client Script

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '') {
        return;
    }

    //Type appropriate comment here, and begin script below
    g_form.addInfoMessage('Assigned to changed. New Value: ' + newValue);

    var userSysId = newValue;

    if (userSysId) {
        var ga = new GlideAjax('UserInfo');
        ga.addParam('sysparm_name', 'getUserInfo');
        ga.addParam('sysparam_assignedto', userSysId);
        ga.getXML(callback);
    }

    // g_form.addInfoMessage(response + 'TesteResponse');

    function callback(response) {

        var answer = response.responseXML.documentElement.getAttribute("answer");
        var returneddata = JSON.parse(answer);
        g_form.setValue("u_email", returneddata.email);
        g_form.setValue("u_country", returneddata.country);
    }


}

Script Include (**Make sure it is client callable)

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

getUserInfo: function() {

		var userId= this.getParameter('sysparam_assignedto');
        var gr = new GlideRecord('sys_user');
        gr.addQuery('sys_id', userId);
        gr.query();

        if (gr.next()) {
            var jsonObj = {};
                jsonObj.country= gr.location.country.getDisplayValue(),
                jsonObj.email= gr.getValue('email');
          
        }
        return JSON.stringify(jsonObj);
    },


    type: 'UserInfo'
});

Output:

Kindly mark my reply as Helpful and/or Accept Solution, if applicable. Thanks!

[F_bio Santos]

Yup, it worked I did some changes to the code, to better suit what I needed but it worked, also I was forgetting to check the "Client Callable" on the script include ...

[Servicenow34]

oh okay !

Thanks for the acceptance 🙂

[Allen Andreas]

Hi @F_bio Santos 

Yes, which is what I called out above.

It's unfortunate that none of my replies were marked as "Accept Solution" consider the information I provided or at a minimum...Helpful.

I'm glad the reply above helped you, but it copies a lot of what I already said even including a line from my own signature at the bottom...lol...

Take care!