Can it be solved with a regular input field and showing the results in stacked Repeating Groups instead? You can filter the results through the “Any field contains”.
As far as I know, the Search Input only supports one field.
It is messy, but you could create a separate combined “search” field thing that has all the city names and codes in the same field (assumption is that it is fairly static so that admin overhead isn’t huge). Each entry then points to an Airport thing.
Then you can do typeahead on that and the selection can drive the airport selected.
This is what I also do for more complex searches. I have a data type called “search index” and store a text field called type and another field of the actual type(s) I’m searching on (e.g. searching users and tags, potential types can be “user” and “tag”; then I’ll direct to the appropriate page based on the type and pass the user or tag payload that is stored on the search index).
But if I combine codes + airport names into one field in the DB how can they correlate to one another?
An airport has a name, city, and code (1 line in the db). If I combine all 3 lines into 1 column and search against it how can I access the other correlated data?
40,000 airports and it looks like i need to add 2 rows and splice out the airport code + name + city so that there are 3 fields pointing to the one airport… Is this correct thinking?
Besides the larger factor of rows being stored, you’ll have to manage each set of search indices multiple times when creating and deleting the main object to make sure you don’t have any orphaned objects laying around.