Show a Variable if the logged In User is the Manager of the current group in catalog Item

[BKSharma]

Hi,

I've few variables in a catalog Item as below -

Requested By

Manager

Secondary Manager

Group Name

List of Users

My requirement is to show the List Control variable (List of Users), if the logged in user is the Manager of current group (Group Name). For other users this 'List of Users' variable will be invisible for other users.

And 2nd requirement is how I can auto populate all the list of users into this List Collector variable depended upon the Group Name variable.

[JenniferRah]

For showing/hiding the List of Users variable, you will need to either write a script in a UI Policy or write a Client Script that runs when the Group Name changes.

For the List Collector list of users, you will need to write a scripted Reference Qualifier to look up the active users in that group and set the qualifier to those users.

[Ankur Bawiskar]

@BKSharma 

For both of your requirements, create onChange catalog client script on Group Name variable and use GlideAjax

onChange catalog client script

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || !newValue) {
        g_form.setDisplay('list_of_users', false);
        g_form.clearValue('list_of_users');
        return;
    }

    var ga = new GlideAjax('GroupManagerCheckAjax');
    ga.addParam('sysparm_name', 'checkGroupManagerAndUsers');
    ga.addParam('sysparm_group_sysid', newValue);

    ga.getXMLAnswer(function(response) {
        if (!response) {
            g_form.setDisplay('list_of_users', false);
            g_form.clearValue('list_of_users');
            return;
        }

        var result = JSON.parse(response);

        if (result.isManager === true) {
            g_form.setDisplay('list_of_users', true);
            g_form.setValue('list_of_users', result.userSysIds);
        } else {
            g_form.setDisplay('list_of_users', false);
            g_form.clearValue('list_of_users');
        }
    });
}

Script Include: It should be client callable

var GroupManagerCheckAjax = Class.create();
GroupManagerCheckAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {
  
  checkGroupManagerAndUsers: function() {
    var userId = gs.getUserID();
    var groupSysId = this.getParameter('sysparm_group_sysid');
    var grGroup = new GlideRecord('sys_user_group');

    if (!grGroup.get(groupSysId)) {
      return JSON.stringify({ isManager: false, userSysIds: '' });
    }

    var isManager = (grGroup.getValue('manager') == userId);
    var userIds = [];

    var grMembership = new GlideRecord('sys_user_grmember');
    grMembership.addQuery('group', groupSysId);
    grMembership.query();
    while (grMembership.next()) {
      userIds.push(grMembership.getValue('user'));
    }

    return JSON.stringify({
      isManager: isManager,
      userSysIds: userIds.join(',')
    });
  }

});

If my response helped please mark it correct and close the thread so that it benefits future readers.

[BKSharma]

Hi @Ankur Bawiskar ,

The solution you've provided, I see that it partially working. 

Menas, if the requested by user is the group Manager then List of Users of that particular variable is showing up, but the list of user it's showing all the users. Instead it should show the list of users currently that particular group is having. 

[Ankur Bawiskar]

@BKSharma 

it should give only those users which are member of selected group.

Did you add log and see what came in that JSON?

If my response helped please mark it correct and close the thread so that it benefits future readers.