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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2023 09:42 AM - edited 05-31-2023 09:45 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-07-2024 04:55 AM
I did not, and I have since moved on to other things. Perhaps try the solution mentioned by @Community Alums and let us know...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2024 07:36 PM
Script for Reference Qualifier:
var query = "nameLIKE" + current.variables.search_term;
query += "^ORsearch_keywordsLIKE" + current.variables.search_term;
query;