Search by Roles

[vidhya_mouli]

In the sys_user table, I am unable to search users by roles. Why is the search option disabled?

Note: I understand that I can use filter to search, but I am just curious to know why, in this place, it is disabled.

[Aman Kumar S · Accepted solution]

Hi @vidhya_mouli 

sys_user.roles is a glide_list field that used to store a user's roles before Contextual Security. With Contextual Security, the related list is used instead, and roles field is not used. And you can't perform search operation on glide_list in form layout, you can checkout other list fields on other tables, such as Type field on Group table.

If you are looking to search for roles, try using "sys_user_role" table.