Constrain the assignment group field

This example shows how to use an advanced reference qualifier with JavaScript and a script include to restrict the incident Assignment group choices to only the groups that contain the user specified in the Assigned to field.

1. Open an incident.
2. Right-click the Assignment group label and select Configure Dictionary.
3. If the form appears in Default view, under Related Links, click Advanced view.
4. In the Use reference qualifier field, ensure that the Advanced option is selected.
5. In the Reference qual field, enter javascript:new BackfillAssignmentGroup().BackfillAssignmentGroup().
6. Save the record.
7. Navigate to System Definitions > Script Includes.
8. Click New.
9. Create a script include with the following JavaScript code. Ensure that the Client callable option is selected and that the Accessible form field is properly set for the environment.

   var BackfillAssignmentGroup = Class.create();
   BackfillAssignmentGroup.prototype = {
     initialize: function() {
     },
    
     BackfillAssignmentGroup:function() {
       var gp = ' ';
       var a = current.assigned_to;
    
       //return everything if the assigned_to value is empty
       if(!a)
   	return;
       //sys_user_grmember has the user to group relationship
       var grp = new GlideRecord('sys_user_grmember');
       grp.addQuery('user',a);
       grp.query();
       while(grp.next()) {
   	if (gp.length > 0) {
   	  //build a comma separated string of groups if there is more than one
   	  gp += (',' + grp.group);
   	}
   	else {
   	    gp = grp.group;
   	}
       }
       // return Groups where assigned to is in those groups we use IN for lists
       return 'sys_idIN' + gp;
     },
     type: 'BackfillAssignmentGroup'
   }