Populate the logged in user's group

[Samiksha2]

Hi All,

I have created a Reference field in the Requested Item.(Requester Group- Reference to sys_group table). 

The requirement is to show the logged in user's group in that field without adding any reference qualifier in the dictionary because this field is been used in other scripts.

Please help in this. 

Thanks,

Samiksha

[Samiksha2]

Thanks @AnveshKumar M ,

It worked.

[Ankur Bawiskar]

@Samiksha2 

Is this a custom field? what's the use of this?

Which logged in user are you referring?

[RAMANA MURTHY G]

Hello @Samiksha2 

You can write onLoad client script, and call the Client callable script include using GlideAjax to query the current logged-in User's group.

onLoad Client Script on Requested Item table

function onLoad() {
   //Type appropriate comment here, and begin script below
   var loggedinUser = g_user.userID;    // It gives current logged in user sys_id
   var gAjax = new GlideAjax('PopulateLoggedinUserGroup');
   gAjax.addParam('sysparm_name','populateGroup');
   gAjax.addParam('sysparm_user',loggedinUser);

   gAjax.getXML(populateGroup);

   function populateGroup(response){
	var returnGroup = response.responseXML.documentElement.getAttribute('answer');
	g_form.setValue('u_requester_group',returnGroup);
   }
}

Client Callable Script include

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

	populateGroup: function(){
		var userId = this.getParameter('sysparm_user');
		var userGroup = new GlideRecord('sys_user_grmember');
		userGroup.addQuery('user',userId);
		userGroup.query();
		if(userGroup.next()){
			return userGroup.group;
		}
	},
    type: 'PopulateLoggedinUserGroup'
});

Please mark my answer as Helpful, if it helps you

Thank you