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

[shruti_tyagi]

Yes I agree with Divya I would still use sys_user_has_role table and thats what has this information. And I guess thats where glide list field Roles is pulling this information...

If you are worried about performance make sure the query you will be making is properly indexed.

Thanks

Shruti

If the reply was informational, please like, mark as helpful or mark as correct!

[divya mishra]

Hi Giri,

I would say unless the fields are populated, we cannot rely on any reports as it would give the vague data.

Best practice would be create role for each users and the try creating reports for the same

Let me know if this was helpful/correct

Have a lovely day ahead

Regards,

Divya Mishra

[Vijay68]

How to get the role id for ITIL role

[Imran Ahmad1]

Hii @Vijay,

Navigate to: sys_user_role.list

Select role and right click copy sys_id.

Regards,

Imran Ahmad

If Correct Mark Helpful below:-