Hi @RWHeals ,
As I understand you will want to adjust (add or remove) members from the group whenever Supervisors field get changes, correct?
How about if the member get removed or added manually not through Supervisors field? Will that field reflect the change also? If not it will be a mess with Group members table.
Anyway, I will give you the BR script that will help to adjust members base on the Supervisors field. Any manual changes will not reflect the field value.
Steps:
1. Check if the field is empty => remove all members from Group.
2. If not, get all existing group members (in sys_user_grmember).
3. Compare with current field value to decide which member to add/remove.
Business Rule (Insert and Update) - on After - Condition: [Supervisors changes]
(function executeRule(current, previous /*null when async*/ ) {
// === If the field is empty then remove all group members ===
if (current.u_supervisors.nil()) {
var member = new GlideRecord('sys_user_grmember');
member.addQuery('group', current.sys_id.toString());
member.query();
while (member.next()) {
member.deleteRecord();
}
return;
}
// === END ===
var existingMem = [];
var addItem = [];
var removeItem = [];
var currentSup = current.u_supervisors.toString().split(',');
// === Get all existing group members ===
var grmember = new GlideRecord("sys_user_grmember");
grmember.addquery("group", current.sys_id.toString());
grmember.query();
while (grmember.next()) {
existingMem.push(grmember.user.sys_id.toString());
}
// === END ===
var arrayToLoop =
existingMem.length > currentSup.length ? existingMem : currentSup;
for (var i = 0; i < arrayToLoop.length; i++) {
if (existingMem.indexOf(currentSup[i]) == -1) {
if (currentSup[i]) {
addItem.push(currentSup[i]);
}
}
if (currentSup.indexOf(existingMem[i]) == -1) {
if (existingMem[i]) {
removeItem.push(existingMem[i]);
}
}
}
if (removeItem.length) { // REMOVE members
removeItem.forEach(function(itemOut) {
var member = new GlideRecord('sys_user_grmember');
member.addQuery('user', itemOut);
member.addQuery('group', current.sys_id);
member.setLimit(1);
member.query();
if (member.next()) {
member.deleteRecord();
}
});
}
if (addItem.length) { // ADD members
addItem.forEach(function(itemAdd) {
if (itemAdd) {
var member = new GlideRecord('sys_user_grmember');
member.addQuery('user', itemAdd);
member.addQuery('group', current.sys_id);
member.query();
if (!member.next()) {
member.initialize();
member.group = current.sys_id;
member.user = itemAdd;
member.insert();
}
}
});
}
})(current, previous);
Tell me if you need to adjust any logic.
