How to use Variable Attributes on a reference field?

[Annie10]

Hello, 

How to display only the user First and Last name on the sys_user table?

I used variable attributes like this, but it is not working.  please help.  Thanks

[Aj59]

@Annie10 

You can achieve this by configuring

1.  Clicking on Gear icon (User Personalize List) select Fist name , last name  and remove other from list collector.

2. Configure>List Layout

** Any one at a time but not both..
You have personalized this list with the list mechanic.

Note: You will not see changes made here until your personal list is reset to column defaults.

Reference qualifier can may be useful here in case of list view but can be more on catalog forms/forms.

Kindly appreciate the efforts of Servicenow community contributors by marking our response as HELPFUL or ACCEPT SOLUTION , this may help other community users to follow correct solution in future...

[sunwin93]

Hi @Annie10 ,

Whenever you will try to access table from reference table, please do the right click>configure> list layout > and please keep required fields in selected bucket.

This will lead to fulfill your requirement.

Please keep in mind that this will make changes in all forms where this table is referred in reference field.

Please mark helpful if you find so.

Thank you

Sanjeet

[Annie10]

Thank to all your suggestions.  

I also have a lookup box where it gets populated user’s manager name using the sys_user table.  If I configure the list layout, it will affects not only the requested for, but also the manager field as well. 

[M Ismail]

Hi @Annie10 
This is how you can do this :
Open your list layout
Right click on 3 dots of any field of list layout
Then click on configure
click on list layout
select only the columns you want to show and remove the other columns
save the changes
that will only show the fields you have selected on list layout