question Emptying a glide_list field in Community Central forum

Emptying a glide_list field

joaopalmeida — Tue, 15 Apr 2025 15:22:14 GMT

Hello everyone!

Hope you are all doing well. I have a question regaring the field "Type" from the table sys_user_group. Basically we have a business rule running after a deletion. I'll leave the code here (EDIT):

(function executeRule(current, previous /*null when async*/ ) { // Get the group name from the deleted group-role record var groupName = current.group.name.toString(); var fulfillerType = false; var approverType = false; // Collect all remaining roles for the group var roleGR = new GlideRecord('sys_group_has_role'); roleGR.addQuery('group', current.group.toString()); roleGR.query(); var remainingRoleIds = []; while (roleGR.next()) { remainingRoleIds.push(roleGR.role.name.toString()); // Use sys_id for proper license_role lookup } gs.addInfoMessage(remainingRoleIds.join(',').toString()); // Now check license_role table for any roles that are of type 'fulfiller' or 'approver' if (remainingRoleIds.length > 0) { var licenseGR = new GlideRecord('license_role'); //licenseGR.addQuery('name', 'IN', remainingRoleIds.join(',').toString()); licenseGR.addEncodedQuery('license_role_typeSTARTSWITHFulfiller^ORlicense_role_typeSTARTSWITHApprover^nameIN' + remainingRoleIds.join(',').toString()); licenseGR.query(); if (licenseGR.hasNext()) { gs.addInfoMessage('Group "' + groupName + '" still has fulfiller or approver roles assigned.'); while (licenseGR.next()) { var roleType = licenseGR.license_role_type.toString(); var roleName = licenseGR.name.toString(); gs.addInfoMessage(roleName + ': ' + roleType); if (roleType == 'fulfiller') { gs.addInfoMessage('Role: ' + roleName + ' - Fulfiller'); fulfillerType = true; } else if (roleType == 'approver') { gs.addInfoMessage('Role: ' + roleName + ' - Approver'); approverType = true; } } } else { gs.info('Group "' + groupName + '" no longer has any fulfiller or approver roles.'); } } var groupGR = new GlideRecord('sys_user_group'); if (fulfillerType && approverType) { if (groupGR.get(current.group.toString())) { groupTypes = ['9c774e5dfb7ce61468bcfcbaaeefdc6a', '96c782ddfb7ce61468bcfcbaaeefdcd5']; // Sys_id Fulfiller Type & Approver Type groupGR.type = groupTypes.join(','); groupGR.update(); gs.addInfoMessage('UPDATED BOTH'); } } else if (fulfillerType && !approverType) { if (groupGR.get(current.group.toString())) { groupTypes = ['9c774e5dfb7ce61468bcfcbaaeefdc6a']; // Sys_id Fulfiller Type groupGR.type = groupTypes.join(','); groupGR.update(); gs.addInfoMessage('UPDATED FULFILLER'); } } else if (approverType && !fulfillerType) { if (groupGR.get(current.group.toString())) { groupTypes = ['96c782ddfb7ce61468bcfcbaaeefdcd5']; // Sys_id Approver Type groupGR.type = groupTypes.join(','); groupGR.update(); gs.addInfoMessage('UPDATED APPROVER'); } } else { groupTypes = ['']; // Sys_id Approver Type groupGR.type = groupTypes.join(','); groupGR.update(); gs.addInfoMessage('REMOVED ALL ROLES'); } })(current, previous);

Everything on this Business Rule runs well, except the else. When we don't find any roles that are from the type "Approver" or "Fulfiller" we basically want to empty the field "Type" on sys_user_group. On any of the conditions it fills the field with the right type, if there's one of each or more left it gets both types on the field, if it finds atleast one from both it also fills the field well. Problem is if it doesn't find any types on the form or if there are no roles associated at all. It enters our else, shows the info message we have for debug but doesn't clear the value. How can we make this work?

Thanks in advance!

Re: Emptying a glide_list field

Ankur Bawiskar — Tue, 15 Apr 2025 15:00:51 GMT

@joaopalmeida

try this

Changes done

Query the sys_user_group record: Ensure the groupGR object is queried for the current group before updating the type field.
Clear the type field: Set groupGR.type to an empty string to clear the field when no roles of type "Approver" or "Fulfiller" are found.

(function executeRule(current, previous /*null when async*/) { // Get the group name from the deleted group-role record var groupName = current.group.name.toString(); var fulfillerType = false; var approverType = false; // Collect all remaining roles for the group var roleGR = new GlideRecord('sys_group_has_role'); roleGR.addQuery('group', current.group.toString()); roleGR.query(); var remainingRoleIds = []; while (roleGR.next()) { remainingRoleIds.push(roleGR.role.name.toString()); // Use sys_id for proper license_role lookup } gs.addInfoMessage(remainingRoleIds.join(',').toString()); // Now check license_role table for any roles that are of type 'fulfiller' or 'approver' if (remainingRoleIds.length > 0) { var licenseGR = new GlideRecord('license_role'); licenseGR.addEncodedQuery('license_role_typeSTARTSWITHFulfiller^ORlicense_role_typeSTARTSWITHApprover^nameIN' + remainingRoleIds.join(',').toString()); licenseGR.query(); if (licenseGR.hasNext()) { gs.addInfoMessage('Group "' + groupName + '" still has fulfiller or approver roles assigned.'); while (licenseGR.next()) { var roleType = licenseGR.license_role_type.toString(); var roleName = licenseGR.name.toString(); gs.addInfoMessage(roleName + ': ' + roleType); if (roleType == 'fulfiller') { gs.addInfoMessage('Role: ' + roleName + ' - Fulfiller'); fulfillerType = true; } else if (roleType == 'approver') { gs.addInfoMessage('Role: ' + roleName + ' - Approver'); approverType = true; } } } else { gs.info('Group "' + groupName + '" no longer has any fulfiller or approver roles.'); } } // Update the group type field var groupGR = new GlideRecord('sys_user_group'); if (groupGR.get(current.group.toString())) { if (fulfillerType && roleGR.getRowCount() <= 1 || approverType && roleGR.getRowCount() <= 1 || !approverType && !fulfillerType) { groupGR.type = ''; // Clear the type field groupGR.update(); gs.addInfoMessage('REMOVED ALL ROLES'); } } })(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Emptying a glide_list field

joaopalmeida — Tue, 15 Apr 2025 15:20:37 GMT

Hi @Ankur Bawiskar , I was actually mistaken when sending this snipped. This is from another business rule, the one we have working is this one:

Re: Emptying a glide_list field

Ankur Bawiskar — Tue, 15 Apr 2025 15:36:27 GMT

@joaopalmeida

so is this script working as expected?

If yes then close the thread by marking your own response as correct.

Re: Emptying a glide_list field

joaopalmeida — Tue, 15 Apr 2025 15:39:05 GMT

No @Ankur Bawiskar. Everything here runs correct until it enters the last else. It shows the InfoMessage present inside, but it doesn't clear the field value as it's supposed

Re: Emptying a glide_list field

Ankur Bawiskar — Tue, 15 Apr 2025 15:51:21 GMT

@joaopalmeida

try this

(function executeRule(current, previous /*null when async*/ ) { // Get the group name from the deleted group-role record var groupName = current.group.name.toString(); var fulfillerType = false; var approverType = false; // Collect all remaining roles for the group var roleGR = new GlideRecord('sys_group_has_role'); roleGR.addQuery('group', current.group.toString()); roleGR.query(); var remainingRoleIds = []; while (roleGR.next()) { remainingRoleIds.push(roleGR.role.name.toString()); // Use sys_id for proper license_role lookup } gs.addInfoMessage(remainingRoleIds.join(',').toString()); // Now check license_role table for any roles that are of type 'fulfiller' or 'approver' if (remainingRoleIds.length > 0) { var licenseGR = new GlideRecord('license_role'); licenseGR.addEncodedQuery('license_role_typeSTARTSWITHFulfiller^ORlicense_role_typeSTARTSWITHApprover^nameIN' + remainingRoleIds.join(',').toString()); licenseGR.query(); if (licenseGR.hasNext()) { gs.addInfoMessage('Group "' + groupName + '" still has fulfiller or approver roles assigned.'); while (licenseGR.next()) { var roleType = licenseGR.license_role_type.toString(); var roleName = licenseGR.name.toString(); gs.addInfoMessage(roleName + ': ' + roleType); if (roleType == 'fulfiller') { gs.addInfoMessage('Role: ' + roleName + ' - Fulfiller'); fulfillerType = true; } else if (roleType == 'approver') { gs.addInfoMessage('Role: ' + roleName + ' - Approver'); approverType = true; } } } else { gs.info('Group "' + groupName + '" no longer has any fulfiller or approver roles.'); } } var groupGR = new GlideRecord('sys_user_group'); if (groupGR.get(current.group.toString())) { if (fulfillerType && approverType) { groupGR.type = '9c774e5dfb7ce61468bcfcbaaeefdc6a,96c782ddfb7ce61468bcfcbaaeefdcd5'; // Sys_id Fulfiller Type & Approver Type groupGR.update(); gs.addInfoMessage('UPDATED BOTH'); } else if (fulfillerType && !approverType) { groupGR.type = '9c774e5dfb7ce61468bcfcbaaeefdc6a'; // Sys_id Fulfiller Type groupGR.update(); gs.addInfoMessage('UPDATED FULFILLER'); } else if (approverType && !fulfillerType) { groupGR.type = '96c782ddfb7ce61468bcfcbaaeefdcd5'; // Sys_id Approver Type groupGR.update(); gs.addInfoMessage('UPDATED APPROVER'); } else { groupGR.type = ''; // Clear the type field groupGR.update(); gs.addInfoMessage('REMOVED ALL ROLES'); } } })(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Emptying a glide_list field

joaopalmeida — Wed, 16 Apr 2025 17:24:44 GMT

@Ankur Bawiskar Thanks! It worked like a charm. 😀