Can someone identify what is wrong with this script?

[Lisa Goldman]

Hello,

I'm attempting to populate my direct reportee text box based on the name in the 'My name' box, but I couldn't get it to work. Can someone identify what is wrong with this script? Thank you.

Client Scripts:

function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading || newValue == '') {

        return;

    }

    var requestor = g_form.getValue('my_name');

    var ga = new GlideAjax('UserUtils');

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

    ga.addParam('sysparm_user', requestor);

    ga.getXMLAnswer(populateDirectReports);

    function populateDirectReports(answer) {

        if (answer) {

            var arr = JSON.parse(answer);

            var direct_reports = arr.join("\n");

            g_form.setValue('my_direct_reportee_text', direct_reports);

        }

    }

}

Script Include:

Client callable option is checked

var UserUtils = Class.create();

UserUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getDirectReports: function() {

        var directReports = [];

        var grUser = new GlideRecord('sys_user');

        grUser.addActiveQuery();

        grUser.addQuery('manager', this.getParameter('sysparm_user'));

        grUser.orderBy('name');

        grUser.query();

        while (grUser.next()) {

            directReports.push(grUser.getValue('name'));

        }

        return JSON.stringify(directReports);

    },

    type: 'UserUtils'

});

[Harish KM · Accepted solution]

Hi @Lisa Goldman there is a error in your script include

getDirectReports: function() {

var directReports = [];

var grUser = new GlideRecord('sys_user');
grUser.addActiveQuery();
grUser.addQuery('sys_id',this.getParameter('sysparm_user')); // need to get user's manager, in this case abraham manager
//grUser.addQuery('manager', this.getParameter('sysparm_user'));
grUser.orderBy('name');
grUser.query();

while (grUser.next()) {
directReports.push(grUser.getDisplayValue('manager'));// get display value of manager
}

return JSON.stringify(directReports);

},

[Harish KM · Accepted solution]

Hi @Lisa Goldman there is a error in your script include

getDirectReports: function() {

var directReports = [];

var grUser = new GlideRecord('sys_user');
grUser.addActiveQuery();
grUser.addQuery('sys_id',this.getParameter('sysparm_user')); // need to get user's manager, in this case abraham manager
//grUser.addQuery('manager', this.getParameter('sysparm_user'));
grUser.orderBy('name');
grUser.query();

while (grUser.next()) {
directReports.push(grUser.getDisplayValue('manager'));// get display value of manager
}

return JSON.stringify(directReports);

},

[Lisa Goldman]

Hi @Harish KM ,

One last question: I need to add a popup message in the code if a user does not have a manager. Could you please help?  Thanks

[Harish KM]

Hi @Lisa Goldman you could add else part in client script like below

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var requestor = g_form.getValue('my_name');
var ga = new GlideAjax('UserUtils');
ga.addParam('sysparm_name', 'getDirectReports');
ga.addParam('sysparm_user', requestor);
ga.getXMLAnswer(populateDirectReports);

function populateDirectReports(answer) {

if (answer) {
var arr = JSON.parse(answer);
var direct_reports = arr.join("\n");
g_form.setValue('my_direct_reportee_text', direct_reports);
}
else
{
alert("No Manager found");
}

}
}

[Lisa Goldman]

@Harish KM 

I copied your suggested code. I wonder why the 'else' condition is not triggering.

I have tried the following users, but the alert did not display.