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.

[Shivam Saxena1]

Hi Ankur,

It is referencing hardware table not asset table.

I am able to search using asset_tag but not name.

Thanks.

[Ankur Bawiskar]

Hi,

if the hardware table is alm_hardware then field name is display_name

it worked for me

Are you giving the correct record satisfying the reference qualifier condition of

Discovery Source = Nlyte-US AND Active=true

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

[Shivam Saxena1]

Hi Ankur,

Table is 'cmdb_ci_hardware'.

Thanks.

[Ankur Bawiskar · Accepted solution]

Hi,

then using this it should work

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

Are you checking with admin or non-admins

Regards
Ankur

[Shivam Saxena1]

Hi Ankur,

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

Thanks.