Catalog reference variable Drop down value is showing unwanted values

Varun Sharma · ‎09-26-2023

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

Tai Vu · ‎11-23-2023

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

View solution in original post

Sateesh Kumar D · ‎11-23-2023

Hello,

Make sure to check on alm_asset table display variable not the table you have this reference field on.