how show only display name from reference "Asset" table in "select asset" field

[khaleed]

Hi Folks,

I've attached a screenshot. The need is that, when the "select asset" field is selected, only the display name should be shown—all other columns are displayed. Since I've used a reference qualifier, all columns are displayed. How can I hide all columns other than the display name, how to solve this?

[Dnyaneshwaree]

Hello @khaleed ,

Reference qualifier logic seems ok. You need to add logic in attributes(in same page as image) in the dictionary of same asset field:
ref_ac_columns=name,ref_ac_display_value=true
you can adjust it as per your requirement.

[OlaN]

Hi,

The fields shown in a reference selectbox is defined by a view (sys_ref_list) on the table.

If there is no such list then the default view is used.

So you can try to create/modify the sys_ref_list on that table to remove all fields except the displayfield.