Search using multiple columns in variable

[MaharshiC]

Hi,

I have created a lookup select box variable pointing to the cmn_location table and want the users to search by both the name and the site code but when I add the additional condition in the attribute field it does not show up in the search.

[Ahmmed Ali · Accepted solution]

Hello @MaharshiC 

The ref_ac_columns attribute is applicable only to reference and requested for type of variables. Below you can get all attributes available for variables.

Try changing the type to reference and check.

Thank you,

Ali

[_Gaurav]

Hi @MaharshiC 
Can you try the below code in the variable attributes field

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

 Please mark this as a solution and helpful if this resolves your query.

Thanks!

[Ankur Bawiskar]

@MaharshiC 

It won't work for lookup select box.

If my response helped please mark it correct and close the thread so that it benefits future readers.