Catalog Item Variable to Dynamically List Members of a Group

[fcaruso123]

We have a group defined that contains users who can approve the purchase of certain devices. The catalog item uses the requesting users organization value (from user record) to further filter the group members.

The Group Members variable is a reference type defined to pull from sys_user_grmember:

I see the following after selecting an Organization:

The number of records getting listed in Group Members is correct but I cannot figure out how to get the user name to display.

Thank you

[Community Alums]

Good Morning,

Following up. 

Can you elaborate on the above statement. 

[Brad Bowman]

You showed the behavior in portal, but I'm not sure what you were showing, or what isn't working in portal.

[Community Alums]

got it.

okay,

the members are not showing in the field.  I am assuming because member values are not set. the field is read only and does not display members on the client-side of the form. 

I believe because the names are only in the available and not selected portion, it is not showing. 

when it's set to read only - it shows selected members:

when it is not read only, it shows both:

If I can get the names into the selected section then the read only field will show all members via the portal (client-side)

[Brad Bowman]

Right, the reference qualifier just sets the filter so the correct records can be selected.  If you want to actually set the value of a variable to a list of sys_ids, you can do that with an onChange Catalog Client Script when the existing_assignment_group_name variable changes.  This script will use GlideAjax to call the same Script Include.  For this to work for both (in case the variable is ever not read-only and someone will be manually selecting/editing) you need to change the reference qualifier to:

javascript: 'sys_idIN' + new groupUtils().getGrpMbr(current.variables.existing_assignment_group_name);

Then check the Client callable box on the Script Include.  That may not alter the existing script, so this is what it should look like - also with the new value from the client script/reference qualifier, and a return that works with both: 

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

    getGrpMbr: function(group) {
        var grpsysid = this.getParameter('sysparm_group') || group; //same sysparm_xxxx used in client script
        var usrArr = [];
        var grp = new GlideRecord('sys_user_grmember');
        grp.addQuery('group', grpsysid)
        grp.query();
        while (grp.next()) {
            usrArr.push(grp.user.toString());
        }

        return usrArr.join(',');
    },

    type: 'groupUtils'
});

Back in the client script in the GlideAjax callback then you would just setValue of the list variable to the response.  This should work both in the native UI where there is an Available and Selected boxes, and Service Portal that looks more like List fields.

[Community Alums]

I also changed this to grp.addQuery('group', group);

 This is for anyone else trying to do what I just did.

Final Edit that worked:

Variable:

Script Include:

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

    getGrpMbr: function(group) {
        var usrArr = [];
        var grp = new GlideRecord('sys_user_grmember');
        grp.addQuery('group', group);
        grp.query();
        while (grp.next()) {
            usrArr.push(grp.user.toString());
        }

        return 'sys_idIN' + usrArr.join(',');
    },

    type: 'groupUtils'
};