How to add User record fields in to Personalized List Columns ?

[B Ashok]

Hi Team, 

I have created a few text fields in the User record form to get user location and department, Company details from Azure to ServiceNow. ( Existing Location, Department, and Company look-up fields are not working as we have separate tables in ServiceNow for those, who are not syncing with Azure as mismatching data so I have decided to create text fields )

I need to add these fields to Personalized List Columns in ListView. 

Can you please help, how to add them. 

Want to add the above fields in the below list to filter user details to ease ticket assignmenet 

Thanks

Ashok

[Ankur Bawiskar]

Hi,

So you created custom fields on sys_user table

which table's list view you want to show those?

If that table has field pointing to sys_user then you can configure list layout and dot walk and show the fields in list.

Regards
ankur

[B Ashok]

I want to show those in the Request ITEM list view ( sc_req_item_list). so that we easily find-out user location, company, and department,  will move ticket assignment to a regional engineer directly, instead of opening user record every time to see those details.

Thanks 

Ashok

[Ankur Bawiskar · Accepted solution]

Hi,

So you want to show which user's location, department, company?

requested_for OR opened_by

You can configure list layout of RITM table and accordingly dot walk that field which refers to user table

I am dot walking Request -> Requested For

Regards
Ankur