Reference field display value

[divya123]

i have created one variable called Emp Number and it is reference to ys_user table, when i select record it has to visible employee number value from reference table instead name.

please help me how can i achive it 

[Ankur Bawiskar]

Hi Divya,

Go to sys_user table; configure dictionary

there you should see employee_number column; open that and make it display=true;

go to url below; give your instanceName and then make display=true for that field

https://instanceName.service-now.com/sys_dictionary_list.do?sysparm_query=name%3Dsys_user%5EelementSTARTSWITHemployee_number

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Aksha]

If you want to apply employee number from user table globally, then you can go to user table and mark name display as false and number display as true.

Else if this should be displayed only for one use case, try ref_ac_columns=employeeId,name;ref_ac_columns_display_value=true in variable attributes.(displays both name and id)

[Harsh Vardhan]

why don't you use dictionary override here ? it would be safer side and it won't impact globally .

open the field which you want to show has display true and go to the dictionary override related list , select the form ( table) where you want to show and then checked "Override display value" field. 

[divya123]

it has display only one catalog item , not for other catalog item in that table