Script Includes return sys id instead of user name

[Erica2]

Hello,

I have the following script include calling from client script.  It is currently returning the sys id instead of the name. Could someone please help take a look at the following code and provide suggestion to fix it.  Thank you

var getSelectedGroupMembers = Class.create();

getSelectedGroupMembers.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getMembers:function() {

        var group = this.getParameter("sysparm_group").toString();

        var gr = new GlideRecord("sys_user_grmember");

        gr.addQuery("group",group);

        gr.query();

        var user_array = [];

        while(gr.next()) {

                  user_array.push(gr.getValue('user'));

        }

        if(user_array.length>0)

                   return user_array.toString();

        else

            return 0;

    },

    type: 'getSelectedGroupMembers'

});

This is what is returning to the client script.

Thank you

[Danish Bhairag2 · Accepted solution]

Hi @Erica2 ,

Pls try below code.

var getSelectedGroupMembers = Class.create();

getSelectedGroupMembers.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getMembers:function() {

        var group = this.getParameter("sysparm_group").toString();

        var gr = new GlideRecord("sys_user_grmember");

        gr.addQuery("group",group);

        gr.query();

        var user_array = [];

        while(gr.next()) {

                  user_array.push(gr.user.getDisplayValue());

        }

        if(user_array.length>0)

                   return user_array.toString();

        else

            return 0;

    },

    type: 'getSelectedGroupMembers'

});

Thanks,

Danish

[Danish Bhairag2 · Accepted solution]

Hi @Erica2 ,

Pls try below code.

var getSelectedGroupMembers = Class.create();

getSelectedGroupMembers.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getMembers:function() {

        var group = this.getParameter("sysparm_group").toString();

        var gr = new GlideRecord("sys_user_grmember");

        gr.addQuery("group",group);

        gr.query();

        var user_array = [];

        while(gr.next()) {

                  user_array.push(gr.user.getDisplayValue());

        }

        if(user_array.length>0)

                   return user_array.toString();

        else

            return 0;

    },

    type: 'getSelectedGroupMembers'

});

Thanks,

Danish

[Sandeep Rajput · Accepted solution]

@Erica2 Here is the updated script you should try.

var getSelectedGroupMembers = Class.create();
getSelectedGroupMembers.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    getMembers:function() {
        var group = this.getParameter("sysparm_group").toString();
        var gr = new GlideRecord("sys_user_grmember");
        gr.addQuery("group",group);
        gr.query();
        var user_array = [];
        while(gr.next()) {
                  user_array.push(gr.getDisplayValue('user'));
        }
        if(user_array.length>0)
                   return user_array.toString();
        else
            return 0;
    },
    type: 'getSelectedGroupMembers'
});

[Alka_Chaudhary]

Hello @Erica2 ,

When you are pushing user in the array, get value will return the sys id. So, you can use gr.getDisplayValue('user') or you can dot walk to user name like gr.user.name to get user name.

Please Mark my answers Helpful & Accepted if I have answered your questions.

Thanks,

Alka