Search name, not display name

[Evan Duran]

I'm having a problem where my catalog has a search field to find company names from a table. When searching company names you must start search with ' - '(space, dash, space). This is because every company display name it named this way. Is there a way to make my search field a 'name contains' type field or to look up name rather than display name?

[Musab Rasheed]

Hello,

Basically it takes field whose 'Display' value is true so in this case it has taken 'Name' field because it display value is true and if you want to take 'Display Name' then make display name 'Display' value as true and make false for 'Name' field, this way it will take 'Display name' while showing records in reference field. Other than this I guess you cannot tweak behavior to display name contains something like that.

Please hit like and mark my response as correct if that helps

Regards

[Evan Duran]

thank you I will keep this is mind, maybe i'll use different variable type?

[Aman Kumar S · Accepted solution]

Hi @Evan Duran 

You have the option to enable multiple field search by adding following attributes for to show the display name and search by name, or any other field.

I have shown for user table for reference, here in ref_ac_columns you need to enlist the columns that you want to see

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=first_name;last_name,ref_ac_columns_search=true
Auto-complete for reference fields

Another way that could be used here is to use "Lookup Select box" field, where you can select which field exactly you show 
to be selectable, refer to below link to understand better.
Lookup select box

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂