How Can I Default Value of a list reference to sys_user to be all users in a specific group?

[Carter1]

Hi All,

I have a list field that is referencing the sys_user table (u_user). I have a requirement to pre-populate this list reference with all users from a specific group (Manager Group)

How can I set the default value for my u_user list reference to include all users from a specific group (Manager Group) when someone creates a new record?

I've looked on the forums and online and haven't been able to find anything that would accomplish this. I don't want to hardcode the user names in the default value and want it to dynamically populate with whatever users are in a specific group. 

Any ideas??

[dmathur09]

group_member : function (){
	var members = [];
        groupName = 'sys_id of group'
	var group = new GlideRecord('sys_user_grmember');
	group.addQuery('group',groupName);
	group.query();
	while(gr.next())
	{
	group_member.push(group.sys_id.toString)
}
	}

In the default value field you can call the script include using javascript: new ScriptIncludeName().functionName();

Regards,

Deepankar Mathur

[Carter1]

Hi Deepankar,

Thanks for the response! I tried doing as you mentioned but am having trouble still.. I'm not seeing anything populating on the approver field. 

Script Include:

var populate_final_approvers = Class.create();
populate_final_approvers.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
    group_member: function() {

	var members = [];
	var approverGroup = 'b7b97ec197c60150c3fa3e0e6253af08';

	var group = new GlideRecord('sys_user_grmember');
		group.addQuery('group', approverGroup);
		group.query();
		
	while (group.next()) {
		group_member.push(group.sys_id.toString);
	}
    },

    type: 'populate_final_approvers'
});

Default Value on Approver field:

Am I missing anything?

[dmathur09]

Hi Carter,

Kindly update the script include as below

var populate_final_approvers = Class.create();
populate_final_approvers.prototype = {
    initialize: function() {
    },
	group_member: function() {
	var members = [];
	var approverGroup = 'sys_id of your group';

	var group_mem = new GlideRecord('sys_user_grmember');
		group_mem.addQuery('group', approverGroup);
		group_mem.query();
		
	while (group_mem.next()) {
		members.push(group_mem.user.toString());
	}
		return members.toString();		
    },

    type: 'populate_final_approvers'
};

Default Value

javascript: new populate_final_approvers().group_member();

I am able to get the desired output using the above script. Screenshot below