How to set approval for users with specific role in workflow - Approval user activity script ?

[Ridhima4]

Hi, 

I want the users with specific role to approve a request, My workflow is working fine but the Approval user script is not working, Please help me with the same. Below is my script mentioned:

var answer = [];
var userRole = new GlideRecord('sys_user_has_role');
userRole.addQuery('role', 'x_adsr_recruit.hiring_manager');
userRole.query();
while(userRole.next()){
answer.push(userRole.user.sys_id);
}

Thanks 

[Mark Roethof]

Hi there,

The role field on sys_user_has_role, is a reference. So a sys_id. You are quering now on text. Just update that in your query and your fine, for example using role.name to query on or the sys_id instead of the role name.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Mark Roethof]

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[asifnoor]

Try like this.

var answer = [];
var userRole = new GlideRecord('sys_user_has_role');
userRole.addQuery('role.name', 'x_adsr_recruit.hiring_manager');
userRole.query();
while(userRole.next()){
  answer.push(userRole.user);
}

Mark the comment as a correct answer if this has solved the problem.

[asifnoor]

hi,

What Ankur mentioned is correct. If there are multiple users, just change this 1 line in my code.

 answer.push(userRole.user);

TO

 answer.push(userRole.getValue("user"));