Why empty roles users also listing when I applied filter with roles is snc_internal?

[Manikantahere]

I am trying to filter out uses who are having snc_internal role and who are not having any role.

While doing it I found that when I applied filter in list layout with Roles is snc_internal, I got records but when I when inside of the few records there is no value in roles field. Then how they were falls under this list ??

[Mark Manders]

Please share your query and the table you are querying to. 

Did you also check if the roles field is really empty? Or does it contain a sysid?

[Simon Christens]

Hi Manikantahere

The field "Roles" on sys_user is not used anymore - nor maintained in anyway.

So in case you want to utilize the field then you need to create custom logic to maintain it.

Way way back - like in 2012 or so it was kinda in use but was phased out rather quicky so please do not expect the field to contain valid information