Hello,
I wouldn’t usually make a post but this has me stumped.
I am looking for assitance with one of my database searches.
I have a database of users with their employment histories stored as “experiences”.
These experiences have search-title and search-company which are lowercase.
I want to build a feature to allow users to search for multiple companies and return all users that match words in those companies. For example find all users that work for any of: Apple, Samsung
Some constraints:
- I can’t user something like Algolia as they require fields to have no privacy settings.
- I can’t use Filter:Advanced as the performance is too slow.
What I currently have in place comes close but still doesn’t match exactly:
Using just companies as an example I am searching for:
search-company Is In MyMultiDropdownSearchInput’s Value each item: lowercase: split by ( )
the lowercase is for making the search case insenstive, and the split by was to break up multiple words into one.
this comes close but doesn’t find companies with 2 words, ie. If searching Rio
Rio: Match
Rio Tinto: Currently wont Match
but if searching something like: “Apple” and then also “Samsung”
it will match any user that has worked at either. Desired behaviour.
I have also played around with differnet constraints “contains”, “contains keywords” and couldn’t find my desired results.
Is there any way to complete this sort of search in bubble whereas it picks up those multi word companies. I have hit a wall with this.