Using multiple field data to search in Lookup Select Box

Vishnu N
Tera Contributor

Hi All,

 

I have a look up select box on a catalog item that points to a table of software products. The table contains the software name, publisher, state and couple other fields. I made sure that name, publisher, state fields are available as the lookup label fields in the variable configuration, so that users can search using any of these values and see a result.

 

It works fine when users search for the exact product name or the exact publisher. However, the search fails when users try searching using a combination of the fields. Users typically type "Microsoft Word" or "Microsoft Excel" when searching for word or excel. Is there a way to make the look up select box be able to handle such combinations? Or are there any other options possible?

Any leads is appreciated.

 

Thank you

1 REPLY 1

Medi C
Giga Sage

@Vishnu N 

Please add the following to your "Variable attributes" on your variable on the catalog item

 

 

ref_ac_columns_search=true

 

 

 Make sure the attributes are comma (,) seperated

 


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.