Search on Two Columns with Reference Field Variable

[Shivam Saxena1]

Hi,

There is a reference field named as 'Asset' in my change form.

When we click on search icon we have below columns.

Right now we can able to search based on column 'Name'.

I want a user can able to search the asset directly by typing in refence field using column 'Name' - name and 'Asset Tag' - asset_tag. When he give name then also it will show the result and if the user give asset tag then also he can able to search.

Right now I am getting below error when I am trying to search using asset tag.

Below is the field dictionary :

What script I need to write and where? Please help?

Thanks.

[Ankur Bawiskar]

Hi,

You can use attributes for reference field

Auto-complete for reference fields

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=asset_tag,ref_ac_columns_search=true

Regards
Ankur

[Shivam Saxena1]

Hi Ankur,

I want to search based on 2 columns.

1. name

2. asset_tag

But when I am giving your query in attributes field, it is populating correctly. But when I am trying to search using name then it is giving invalid reference and unable to search.

Giving below query :

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;asset_tag,ref_ac_columns_search=true

Thanks.

[Ankur Bawiskar]

Hi,

which table is being referred?

Is it alm_asset? if yes then the field is display_name and not name

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=display_name;asset_tag,ref_ac_columns_search=true

Regards
Ankur

[Shivam Saxena1]

It is hardware table. Field name is 'name.

[Ankur Bawiskar]

Hi,

it should work fine

the field is display_name

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=display_name;asset_tag,ref_ac_columns_search=true

Regards
Ankur