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.

[Ahmmed Ali]

Hello,

you can add attribute to search with asset tag along with name. add below in attribute field. Open dictionary form in advanced view.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=asset_tag;name

[Ahmmed Ali]

Did you try above?

[Shivam Saxena1]

Hi Ahmmed,

This query is not working. Below query is working partially. It is searching based on asset_tag but not based on 'name'.

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

Thanks.

[kaminiaggar]

This does not work