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

vidhya_mouli · ‎03-01-2024

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?

swathisarang98 · ‎03-01-2024

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&colon; 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

View solution in original post

swathisarang98 · ‎03-01-2024

@vidhya_mouli , just for confirmation once you select Employee Name, you are clicking on Group field Search icon right ? thats when reference qualifier calls the Script include.

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

Regards,

Swathi Sarang

vidhya_mouli · ‎03-01-2024

Yes, but when I clicked on the search, it does not call it.

swathisarang98 · ‎03-01-2024

@vidhya_mouli , have you created your script include in scoped Application? if yes while calling add api name

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

Regards,

Swathi Sarang

vidhya_mouli · ‎03-01-2024

Yes

swathisarang98 · ‎03-01-2024

Dont check client callable in script include because we are calling from server side to server side only, Better you delete this one and create a new script include and copy the old code and in reference qualifier add api name

javascript&colon; new global.getuserGroup().getgroupDeatils(current.variables.user)