roles field in user table

[Venkat122]

Hi All,

There is a field called "Roles" in user table, it appears that there is no value in the field. But, when i filter like roles--is--itil, then it filtered all the users with ITIL role. How values will be copied into this field. Can we rely on this field to report for tickets created by an ITIL user.

Thanks and regards

Giri

[DilipKumar DJ]

Hi Giri,

All the roles mapped to user will be stored in sys_user_has_role table. Roles field is just to create a relationship with this table. So virtually no roles will be stored in sys_user (User) table.

[Venkat122]

Hi Dilip,

Thanks for your reply.

I know about where roles will be stored. But, just want to understand why correct ITIL user records are showing when we filter with roles -- is--itil.

Regards

Swamy

[Shishir Srivast]

The users who do not have any roles are showing up as blank in the list and I think if you are able to filter the list based upon the user role which you give itil then it shouldn't give any problem in reporting as well.

[DilipKumar DJ]

Hi Giri,

As mentioned before roles field in user table virtually   do not have any value, Hence you are not able to filter by itil role. If you need all users who have ITIL role, goto sys_user_has_role.list and filter role->itil and you should get the list.