Group Approval should trigger to Specific user's from group

[pujitha K]

Hi All,

I got a requirement where I need to trigger the approval to specific users from group for change management when 'Request Approval' UI action is clicked.

To accomplish this, I have created a separate table 'u_approvals' with 1 list field named 'Level 1 Approvers' (referring to sysapproval_approver) and one reference field named 'Related Group' (refers to sys_user_group) where list field contains approvers and Reference type field contains Group name.

also, I have created a new field of Type True/False type on Change_request table so that whenever Ui action is clicked we will set this field value to True and created the business rule with below script to run when the value is set to True.

The approvals are getting triggered and User is also showing up on Approvers related list with Approver name but the group name is getting set(i.e., only Approver user is setting but not group).

Is there a way we can map the Group along with User in the Approval record.

(function executeRule(current, previous /*null when async*/ ) {

    // Add your code here

    if (current.approval == 'requested'){

        current.u_request_approval = false;

        return;

    }

    var appGR = new GlideRecord('u_group_applicable_approvers');

    appGR.addQuery('u_group', current.assignment_group);

    appGR.query();

    while (appGR.next()) {

        var memberList = appGR.u_st_level_approver.toString();

        if (!memberList)

            continue;

        var memberArr = memberList.split(',');

        for (var i = 0; i < memberArr.length; i++) {

            var memberGR = new GlideRecord('sys_user_grmember');

            if (!memberGR.get(memberArr[i]))

                continue;

        var dup = new GlideRecord('sysapproval_approver');

        dup.addQuery('sysapproval',current.sys_id);

        dup.addQuery('approver',memberGR.user);

        dup.query();

        if(dup.hasNext())

        continue;

            var approvalGR = new GlideRecord('sysapproval_approver');

            approvalGR.initialize();

            approvalGR.sysapproval = current.sys_id;

            approvalGR.group = memberGR.group;

            approvalGR.approver = memberGR.user;

            approvalGR.state = 'requested';

            approvalGR.insert();

        }

    }

    current.approval = 'requested';

    current.u_request_approval = false;

    current.update();

})(current, previous);

When I check Chat gpt it's saying that it's working as per the functionality of ServiceNow i.e., we can set either Group Approval or User Approval but not both.

Please help with your inputs on this.

Thanks,

Pujitha

[lauri457]

Don't let chatgpt do your solutioning. Look into change approval policies. And at the very least drop the custom tables for this.

There is no assignment group in your user approval as the assignment group is stored on the group approval record which you don't have (field in yellow highlight is sysapproval_approver.group.assignment_group). You can just add your l1 approvers into a separate group and create a group approval for that group and the user approvals will be created by the oob business rules.

[Brad Bowman]

This requirement is not sound as it is attempting to circumvent system functionality.  'Request Approval' should generate approvals to the members of a group, as it does out of the box - not some members.  A different group should be used if not every member should receive the approval.