We have a collection "customers" that has around 100 records in it. Four other collections have a relationship field relating to "customers." When running locally and connected to a local mongoDB, there are no issues and one can easily use the search bar on the other collections "customer" relationship field to select the appropriate "customer record" for the relationship field. However, when running the application remotely and connected to a remote mongoDB, we start running into issues.
If, we search for a record that is not included in the first 10 records returned, the record will not be found and "no options" will appear in the dropdown, then if we scroll down the dropdown, no more options are fetched. If we refresh the page and scroll down the options list instead of searching, the options will continue to fetch the customer records options and we are able to find and select the appropriate record.
Any ideas as to what might be causing this?
Including the fields we were using to search ("name", "id") in the "listSearchableFields" array under the collection config and then setting "index: true" on the field, solved this issue for us.