Catalog reference variable Drop down value is showing unwanted values

[Varun Sharma]

Hi Experts, 

I'm trying to configure a catalog variable which uses a reference qualifier to show multiple columns in drop down list, 

i'm using the below mentioned attributes, 

ref_auto_completer=AJAXTableCompleter, 
ref_ac_columns =asset;task;location,
ref_ac_columns_search=true,
ref_ac_display_value=true

but it's showing an additional column "sys_created_on" 

display value on referenced table for "sys_created_on" field is false. 

Kindly guide me to navigate through this requirement. 

Regards, 

Varun Sharma

[Vishal Birajdar]

Hi @Varun Sharma 

Can you check on table if there is any other field have display= true;

[Varun Sharma]

I did , and that doesn't seem to be the issue. as created field is set to false. which is the issue here. 

[Sandeep Rajput]

@Varun Sharma Please check if you have any column set to display true on the table referenced in the reference field. If there are no columns set to display true, the system might have added the sys_created_on as a default column for display. 

[Tai Vu · Accepted solution]

Hi @Varun Sharma 

In the Reference variable type, the first column is always the display value.

And the Reference fields look for the display value in the following order:

• A field with display=true in the system dictionary on the lowest sub-table for extended tables.
• A field with display=true in the system dictionary on the parent table.
• A field named name or u_name.
• The Created on field of the referenced record.

In your situation, since there's no field marked with Display as true in the table, the Created on field will be utilized.

So let's check the Display to True for one field (Ex: Asset) that you'd like to set as the display value. This will result in the Asset becoming the first column.

Cheers,

Tai Vu