Using multiple field data to search in Lookup Select Box
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-05-2025 01:17 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-05-2025 01:25 PM - edited 03-05-2025 01:26 PM
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.