Reference Field - Can you Search on a Column which is not Displayed?

G24
Kilo Sage

Hello.  Is there any concept of Keywords or Aliases or Search Terms which would allow a Portal user to find a records in a catalog item question (referenced field) without those search terms actually appearing in the search dialog?

 

For example.  Say I have a Car table, and I want the user to be able to search for, see, and select the Make:

   BMW

   Ford

   Mercedes

   Nissan

 

But I also want "Ford" to pop up if the user types in F150, F250, or F350, or Ranger.

And I want "BMW" to pop up if the user types in 318, 325, M3, X5, etc. 

And I do not want to SHOW the user these additional search terms in the selection / search dialog.

 

Is there any supported way to configure that?  Thank you!

6 REPLIES 6

I did not, and I have since moved on to other things.  Perhaps try the solution mentioned by @Community Alums  and let us know...

Community Alums
Not applicable

Script for Reference Qualifier:

var query = "nameLIKE" + current.variables.search_term;
query += "^ORsearch_keywordsLIKE" + current.variables.search_term;
query;