Catalog item: How to get value of one variable based on another variable

[vidhya_mouli]

I have catalog item with 2 variables employee and group. Employee is a reference field based on sys_user table. Group is also a reference field based on sys_user_group table. When I choose the value of the employee, i want to display only those group to which this employee belongs. How to do this?

[Dr Atul G- LNG]

Hi @vidhya_mouli 

https://www.servicenow.com/community/itom-forum/show-group-members-for-a-selected-user-on-a-catalog-...

https://www.servicenow.com/community/itsm-forum/get-all-groups-user-is-a-member-of-based-off-of-a-ca...

These will be helpful.

[vermaamit1664]

Hi @vidhya_mouli 

Below posts could be helpful :

https://www.servicenow.com/community/itsm-forum/get-all-groups-user-is-a-member-of-based-off-of-a-ca...

https://www.servicenow.com/community/developer-forum/how-to-populate-group-values-or-group-members-b...

https://www.servicenow.com/community/developer-forum/need-to-populate-the-group-names-which-opened-b...

Thanks & Regards

Amit Verma

[swathisarang98 · Accepted solution]

Hi @vidhya_mouli ,

You can achieve this by creating script include and calling it through reference qualifier,

You can add reference qualifier in Group field like below,

javascript: new getuserGroup().getgroupDeatils(current.variables.user)

Script Include:

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

	getgroupDeatils: function(user){
		var sysId = user;
		var groupName = new GlideRecord('sys_user_grmember');
		groupName.addQuery('user',sysId);
		groupName.query();
		var arr =[];
		while(groupName.next()){
			arr.push(groupName.group.toString());
		}
		gs.info('line number 15 ' + arr);
		// gs.info('line number 16 ' + arr.toString());
		// gs.info('line number 17 ' + arr.getDisplayValue());
			return 'sys_idIN'+ arr;
	},

    type: 'getuserGroup'
};

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[vidhya_mouli]

I used exactly your code but struggling to get the values.

On group field:

javascript: new getuserGroup().getgroupDeatils(current.variables.employee_name)

Script Include:

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

	getgroupDeatils: function(user){
		var sysId = user;
		var groupName = new GlideRecord('sys_user_grmember');
		groupName.addQuery('user',sysId);
		groupName.query();
		var arr =[];
		while(groupName.next()){
			arr.push(groupName.group.toString());
		}
		gs.info('line number 15 ' + arr);
		return 'sys_idIN'+ arr;
	},

    type: 'getuserGroup'
};