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.

[asifnoor]

If the table name is cmdb_ci_hardware (which is not asset table), then try like this.

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

And most importantly when you are searching chck the ref qual conditions and check if you are getting that name there or not.

[asifnoor]

change the reference to chasis table and check it once.

[Shivam Saxena1]

Hi Asif,

It is working for asset. No worries. Thanks for your help.

Thanks.

[asifnoor]

Hi Shivam

I noticed that you have marked my comment as correct answer but now it is not.

if you are using asset table, then the column name is display_name which i have correctly mentioned earlier to you. The comment that you have marked as correct is saying name which is not the case.

Please check and mark appropriate comment as  a correct answer so that others who are looking for similar solution can be benefitted.

[Shivam Saxena1]

yes. corrected. thanks.