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

B Ashok
Tera Guru

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. 

 

find_real_file.png

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

 

find_real_file.png

Thanks

Ashok

 

1 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

find_real_file.png

I am dot walking Request -> Requested For

find_real_file.png

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

B Ashok
Tera Guru

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

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

find_real_file.png

I am dot walking Request -> Requested For

find_real_file.png

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader