OK, let's take a step back for a moment and simplify things.
You want to remove the user from the "Assigned to" field on any active, Task-derived record when the user is removed from a group, correct? So we need to look at all Task records where "Active" is true, the "Assignment group" is the Group the User was just removed from and the "Assigned to" field is the removed user.
To do that, we want to create a new "Advanced", "After Delete" Business Rule on the Group Member table:
So this BR will only trigger whenever a User is removed from a Group.
Here's the code you can use in the Script field:
(function executeRule(current, previous /*null when async*/) {
var groupId = current.getValue("group");
var groupName = current.group.getDisplayValue();
var userId = current.getValue("user");
var userName = current.user.getDisplayValue();
//look for all Active Task records assigned to the Group AND User
var gr = new GlideRecord("task");
gr.addEncodedQuery("active=true^assignment_group=" + groupId + "^assigned_to=" + userId);
gr.query();
while (gr.next()) {
//add a work note to let people know why the field was cleared
gr.work_notes.setJournalEntry("Assigned to field cleared because '" + userName + "' was removed from the current Assignment group '" + groupName + "'");
gr.assigned_to = "";
gr.update();
}
})(current, previous);
OK, let's take a step back for a moment and simplify things.
You want to remove the user from the "Assigned to" field on any active, Task-derived record when the user is removed from a group, correct? So we need to look at all Task records where "Active" is true, the "Assignment group" is the Group the User was just removed from and the "Assigned to" field is the removed user.
To do that, we want to create a new "Advanced", "After Delete" Business Rule on the Group Member table:
So this BR will only trigger whenever a User is removed from a Group.
Here's the code you can use in the Script field:
(function executeRule(current, previous /*null when async*/) {
var groupId = current.getValue("group");
var groupName = current.group.getDisplayValue();
var userId = current.getValue("user");
var userName = current.user.getDisplayValue();
//look for all Active Task records assigned to the Group AND User
var gr = new GlideRecord("task");
gr.addEncodedQuery("active=true^assignment_group=" + groupId + "^assigned_to=" + userId);
gr.query();
while (gr.next()) {
//add a work note to let people know why the field was cleared
gr.work_notes.setJournalEntry("Assigned to field cleared because '" + userName + "' was removed from the current Assignment group '" + groupName + "'");
gr.assigned_to = "";
gr.update();
}
})(current, previous);
