- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2024 01:55 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2024 02:42 AM - edited ‎03-01-2024 02:51 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2024 04:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2024 04:44 AM - edited ‎03-01-2024 05:01 AM
@vidhya_mouli , check whether Abel tuter profile has any Group attached to it if not try adding few and then do your testing ...then Group will give you only the names list which Abel tuter has.
If group is not there then it will show something like below,
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Swathi Sarang
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2024 05:42 AM
He had two groups attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2024 05:46 AM
@vidhya_mouli can you please give me screenshots of log which you are getting ?
and please share the script include screen shot aswell.
Thanks
swathi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2024 06:04 AM
What I noticed was, my script include is not getting called.
javascript: new getuserGroup().getgroupDeatils(current.variables.employee_name)