How to change reference display value on list view only on one table?

[Bart Z]

Hello,
I have a table on which I need to change display value of Location, which is a reference to cmn_location table. Right now there is a name displayed, but I want to display the 'city' attribute instead.
I want to change the display rule only on this one table, so I can't just change the Display attribute in cmn_location dictionary to 'city' attribute.
Any ideas? Maybe I can override it with reference qualifiers?

[Voona Rohila]

Hi Bartłomiej Z

If you change the display value of cmn_location table then those changes will be applied accross your instance where this field is referenced or accessed from back-end.

Instead you can add additional attributes for that field so that along with name you can show city too

samplee:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_field1;u_field2;u_field3,ref_ac_columns_search=true

https://snprotips.com/blog/2016/2/22/referencelist-attributes

https://docs.servicenow.com/bundle/sandiego-servicenow-platform/page/product/service-catalog-managem...

[Bart Z]

Hi,
thanks for tip, it works fine for searching by 'city' attribute, but I still need to change the display value
example:
Here, I need to display 'Gordon' instead of '#2 FILTER', and as you mentioned, I can't change the display value in dictionary of cmn_location, because it will change across the whole instance