Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
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.