how to make a catalog form reference field searchable based on other columns value

[Riya Motavar]

Hello Team,

I have a reference field on a catalog form pointing to table cmdb_ci_computer table. which searches the name field i want to make it able to search based on other column like serial_number values as well.

how to achieve this?

Thanks,

Riya

[Riya Motavar · Accepted solution]

I was able to find solution for this question.  added attribute to the variable as below Thanks.

all_tables.text_index_translations=true,ref_ac_columns_search=true,ref_ac_order_by=name,ref_ac_columns=serial_number,ref_auto_completer=AJAXTableCompleter