How can i fetch user list having a specific role.

[Hemant13]

My requirement:

I have created a role, provisioning_approval.

I have created few users and among them i have assigned this role to 3 of them.

I have a form and there i want to list the approval names(select box).

So do we have a way through client script i can directly fetch users having that role assigned to them.

I tried an onLoad script but not sure how to fetch correct list bcz below is giving me current user name.

if(g_user.hasRole('provisioning_approval')) {
    g_form.addOption('app',g_user.getFullName(), g_user.getFullName());
}

1. Do we have any way to fetch User list based on role
2. Should i go through each user in loop and check their role and add in the drop down list.

Please help and let me know if any other details are required.

[Namrata Khabale]

Hey Hemant,

try like this:

count=0;

var grUserRoles = new GlideRecord('sys_user_has_role');  

grUserRoles.addQuery('role', '282bf1fac6112285017366cb5f867469');   // itil  //Enter Your role

grUserRoles.query();  

while(grUserRoles.next()) {

count++  

gs.print(grUserRoles.getDisplayValue('user'));  

}

gs.print(count);

Mark correct and helpful if you find response Worthy!!

Best Regards,

Namrata.

[RaghavSh · Accepted solution]

If you want all the users with your specific role no need to write script, you can create a lookup select box instead of select box with following conditions:

replace the sys_id of your role, in reference qualifier.

[Hemant13]

Thanks @Namrata and @Raghav for quick response 🙂 

@Raghav it worked when i was logge din as system admin and showing me the drop down list but when i logged in as normal user it did not work, the drop down list showing empty.

can you please let me know if i am missing anything here.

[Namrata Khabale]

Hey Hemant,

Its depend of which sys_id of role is you choose. Other user might not have  that role check it once.

Hope it helps!!

Regards,

Namrata.