Create dynamic approval group based upon user table field?

Isaac10 · ‎10-03-2016

In our Change workflow we have an initial approval by the assignment group. It's an OOB step called Technical Approvals. Our managers are not part of their groups. They have requested:

That they (the managers) be part of the group
That they have the ability to choose who on their teams can approve (they may not want the entire team to be an approver)

To facilitate this we added a true/false button to the user record called: u_change_assessment_approver

How can I tell the approval to look at the assignment group and send the approval request to only those users of that group who have u_change_assessment_approver marked true?

Additionally how can I have it also send that approval to the manager of that group?

Thanks all!

randrews · ‎10-03-2016

dooo sorry much easier.. this is in a change workflow right?? if so do this instead in a user approval script

var answer = [];
var counter = 0;
var failsafe_sid = 'sid of change manager or whoever will approve if there are no active approvers';
answer.push(current.assignment_group.manager.toString()); //this pushes the manager of the group to the approvers
var users = new GlideRecord('sys_user_grmember');
users.addQuery('group',current.assignment_group); //find members of the group
users.addQuery('user.u_change_assessment_approver',true); //check to see if they are a change approver
users.query();
while(users.next()){
answer.push(users.user.toString());
if(users.user.active){
counter++;
}
}
if(counter == 0){answer.push(failsafe_sid)}

View solution in original post

Isaac10 · ‎10-03-2016

That did it!

Thank you to everyone for your help.

Taha3 · ‎02-19-2019

Hi Issac,

What if we want to send approval to any one approver selected from dropdown in Approvers list. We have a particular group where we want only one user of that group which user is selecting the approval should go only to that person.

Any help would be appreciative!

Thanks,

Taha