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]

Hi,

Try like this and it will work.

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

Mark the comment as a correct answer and also helpful once worked.

[Shivam Saxena1]

Hi Asif,

Column name is 'name'.

Not sure why it is not working.

[Ankur Bawiskar]

@Shivam Saxena 

It should work fine provided that name/record satisfied your reference qualifier condition

Below worked for searching on name

Below worked for searching on asset tag

Regards
Ankur

[asifnoor]

Okay.

1. Can you go to hardware.list and take any 1 name and search here and show me what you get?

2. Even in hardware table, the column name is display_name. 

Since there is additional filters check if the given name is meeting those ref qual filters or not as well.

Kindly mark the comment as a correct answer and also helpful once worked.

[Shivam Saxena1]

Hi Asif,

This is the field.

When you click on search then it will show below table.

This table is cmdb_ci_hardware.

Now, if I select any value in reference and open info

it opens below table

My dictionary :

Now please let me know where I am going wrong?

Thanks.