How to check users who has specific multiple roles using table filtering

[Daichi Ishikawa]

I would like to check users who has specific multiple roles and the number of them using table filtering (without scripting).

(e.g. users who has itil role and catalog_admin role)

Does anyone have some answer to this question?

Any help would be greatly appreciated!!

[Ankur Bawiskar · Accepted solution]

@Daichi Ishikawa 

do like this

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Nayan Dhamane]

Hello @Daichi Ishikawa ,

Please paste 'sys_user_has_role.list' on the application navigator. It will open the below table and use the condition along with it group it with user so you can find duplicate.

As you can view above Andrew has only one 'itil' role similarly you can look for two 'itil' roles.

If my response helped please mark it correct and close the thread so that it benefits future readers.

BR,
Nayan

[Daichi Ishikawa]

Thank you for your quick reply!!

I solved this problem to filter [sys_user] table by the multiple roles ("And" condition) as Ankur said.