@lakshmi_laksh
you can use script in the advanced ref qualifier as this so that it shows only the groups for that user which are having pps_resource role
Something like this
javascript: var query = '';
var userGroups = [];
var groups = new global.ArrayUtil().convertArray(gs.getUser().getUserByID(current.userField).getMyGroups());
// Query to check if the group has the pps_resource role
var grGroupRole = new GlideRecord('sys_group_has_role');
grGroupRole.addQuery('group', 'IN', groups.toString());
grGroupRole.addQuery('role.name', 'pps_resource');
grGroupRole.query();
while (grGroupRole.next()) {
userGroups.push(grGroupMember.group.toString());
}
query = 'sys_idIN' + userGroups.toString();
query;
If my response helped please mark it correct and close the thread so that it benefits future readers.
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
