get users with specific role

[lenz1979]

Hello!

i need to fetch all system users which have a specific role. ( to send an email to that users )

is there a way to do this within the sugar functions?

one idea is:
--> select all users directly from mysql-table.
--> go through each row and:
----> $tmp_user = new User();
----> $tmp_user->retrieve_user_id(UIDOFCURRENTROW)
----> $tmp_user->check_role_membership("ROLENAME")


But maybe there is already a method for retrieving all users that belong to a specific role within the sugarcrm framework. ??

any ideas?

[salesagility]

What version and edition are you using?

[lenz1979]

i use community edition 5.2.0a

currently i made it by querying the acl_role* tables..