How to search on different fields on a reference field using reference qualifier

[Krithika R]

Hi All,

I have a catalog variable 'search_cidb' which is a reference field and it is mapped to Account (customer_account) table. On that field I need to search for the customer number but it is search on the account name how should I change that search to customer number? How should I do that.

I used variable attribute to display the customer number too.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_customer_number,ref_ac_columns_search=true,ref_ac_order_by=u_customer_number

[Mohith Devatte]

Hello,

Please try this

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

replace name with your name field back end name

please mark my answer correct if it helps you

[Krithika R]

Hi @Mohith Devatte ,

I need to search based on the customer number only but as of now it is searching the customer number on the name field. So how would I change that.

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

This variable attribute will display the name of the account while searching.

[Mohith Devatte]

Hello @Krithika R 

Can you go to customer_account table  configuration and see which field/column has got display check box as true ?

If it is for name field please uncheck it and for customer number field check display check box to true and try 

Please mark my answer correct if the above solution helps you

[THOUSIF S N1]

did you find any solution apart from changing the display field?