reference field search with Id instead of name

[Gopal14]

Hi Team,

I have a reference field in cmdb_ci table. Currently It is searching with name.

Now I want to search with id instead of name.

In Attributes field I have written bellow

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=id,ref_ac_columns_search=true

Now when I am searching in field now it is displaying both name and id.

I want only ID in reference field.

What modification I need to do in reference field

[Gunjan Kiratkar]

Hi @Gopal14 ,

Is that 'id' OOB field? Because I'm not able to find that in my instance for cmdb_ci table.

[Gopal14]

Hi Gunjan,

I have given example, But my  field is u_site_code

[Gunjan Kiratkar]

Hi @Gopal14 ,

The one way to do that is goto configure dictionary of that field and make visible true as below

Note : This is global change.