Create dynamic approval group based upon user table field?

[Isaac10]

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:

1. That they (the managers) be part of the group
2. 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!

[Isaac10]

Hi Raymond,

Thanks for your response. What you wrote makes sense but it is well beyond my technical expertise to write that script. I have certainly run into the auto-approve behavior in because one of our groups did not populate correctly.

We need to query the members of the group chosen in the assignment_group (variable) field to see which of them has u_change_assessment_approver marked true on the user record . Then, we want add the assignment_group.manager as an approver as well.

I really appreciate the help.

[Chuck Tomasi]

This will do it -

var answer = [];  

var grusr = new GlideRecord('sys_user_grmember');  

grusr.addQuery('group.name','PASS GROUP NAME HERE');  

grusr.addQuery('user.u_change_assessment_approver',true);  

grusr.query();  

while(grusr.next())   {  

  answer.push(grusr.getValue('user'));      

}

// Now add the manager

answer.push(current.assignment_group.manager);

[mathankumar2]

Hi Chuck,

I am looking for a solution for the similar kind of requirement. RITM approval , Catalog task creation should get routed based on the multiple variable values selected by the user while submitting a catalog item.

EX: If an item is submitted with variable values like Urgency is 1, Priority is 2 then approval should be routed to group XYZ, Catalog task should be assigned to group ABC.

Likewise , if another item has Location variable as Europe, Urgency is 2 then approval should be routed to group DEF, Catalog task should be assigned to group 123.

I have created a custom table , added a condition field and made is as a dependent field on another field with type as table which points to the (sc_item_option) table , by this way we can build multiple conditions for the same catalog item but the problem is we are unable to compare the RITM variable values with the conditions stored on the custom table reason being.

Thanks,

Mathankumar R

[randrews]

ok shouldn't be to tough.. lets see if i can steal code from my compatriots...just keep in mind you are NOT putting the code in a GROUP approval but in a user approval.

1. var answer = [];  
2. var counter = 0;
3. var failsafe_sid = 'sid of change manager or whoever will approve if there are no active approvers';
4. var group = new GlideRecord('sys_user_group');
5. group.get(current.variables.assignment_group);   //use the variable or however you are getting the assignment group here.
6. answer.push(group.manager.toString());   //this pushes the manager of the group to the approvers
7. var users = new GlideRecord('sys_user_grmember');
8. users.addQuery('group',current.variables.assignment_group);   //find members of the group
9. users.addQuery('user.u_change_assessment_approver',true);   //check to see if they are a change approver
10. users.query();
11. while(users.next()){
12.       answer.push(users.user.toString());
13.       if(users.user.active){
14.                   counter++;
15.       }
16. }
17. if(counter == 0){answer.push(failsafe_sid)}

[randrews · Accepted solution]

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

1. var answer = [];  
2. var counter = 0;
3. var failsafe_sid = 'sid of change manager or whoever will approve if there are no active approvers';
4. answer.push(current.assignment_group.manager.toString());   //this pushes the manager of the group to the approvers
5. var users = new GlideRecord('sys_user_grmember');
6. users.addQuery('group',current.assignment_group);   //find members of the group
7. users.addQuery('user.u_change_assessment_approver',true);   //check to see if they are a change approver
8. users.query();
9. while(users.next()){
10.       answer.push(users.user.toString());
11.       if(users.user.active){
12.                   counter++;
13.       }
14. }
15. if(counter == 0){answer.push(failsafe_sid)}