We are trying to add a reference qualifier for the field Additional Assignee List to limit the users shown on the lookup for users that are members of a certain group. We can see that there is a filter value for the role the user has but there is none for the groups he is part of.
Hi explorenow thanks for this, we used this and modified a bit to fit on our exact requirement.
For other users with this similar requirement, just refer to the steps below:
Here's the final script we used to achieve our requirements:
var FindGroupMember = Class.create();
FindGroupMember.prototype = {
initialize: function() {
var grp = current.assignment_group;
var x; //Variable that will hold the group of members you want to show
//If Assignment Group is Group A then show members of Group B
if(grp=='<insert sys_id of Group A>'){
x = '<insert sys_id of Group B>';
}
//Code to return members of the group
var answer = [];
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group', x);
gr.query();
while(gr.next()){
answer.push(gr.user.toString());
}
return 'sys_idIN' + answer;
},
type: 'FindGroupMember'
};
HOW TO SETUP:
Create a new script under System Definition > Script Includes
Use the final code above
Configure the Dictionary of Additional Assignee List field
DO NOT change the setup on Reference Specification
Go to Dictionary Overrides on the bottom of the page and click New
Change table to Incident (this allows you to just change the lookup of Additional Assignee List field while you are on Incident table, on other tables, it will just work as OOB)
Check 'Override reference qualifier'
Paste the code below on the R
javascript:new FindGroupMember().initialize();
RESULTS:
When Assignment Group is Group A, then lookup for Additional Assignee List will return users of Group B.
This can be done by modifying the dictionary of additional_assignee_list field. By clicking on the 'Advanced View' in the Related Links, you may create an advanced Reference Qualifier which has script to get the list of sys_ids based on your need (of a specific group, location..etc)
javascript:new UserUtil().getUserIds() is an example. You might have to create your own script and use it here.
Hope this helps. Mark the answer as correct/helpful based on impact.
