Aggregate / SQL: list of users in a Role

Hi all !

I need to find a query to retrieve the list of the users of a particular "Role".

Actually I'm selecting all the users and I cycle all the items with the "CheckXYZRule" ... but I would like to find a better way to do that ...

Thanks !

Hi! 

you can use the User_Role entity from System module. 

Regards

Graça

Hi Maria, thanks for your answer !

I added the "Users_Role" in my sources (now I have the User and the User_Role) ... but what about the "Filters" page ?

The roles I want to check are 118 and 119 (showed in my "OSSYS_ROLE" table) ...

Solution

Hello, you should use the User_Effective_Role because if you're assigning roles by group you can catch them also. For the filters you can use the role like this:

Hope it helps,

Cheers!

Solution

Hi Tiago ... thanks for your reply !

It works perfectly !