Using a contains with any order of values in Native app for address searching
I'm building a small native app that has address searching, ideally what I would like to do is use the contains function, pass in my search parameter and search a string in my entity but in any order of words. I’ve followed this tutorial: https://medium.com/mendix/how-to-create-a-search-functionality-in-a-mendix-native-mobile-app-f6f48b59f1be In my entity I have an address of “10 Main Street”, what I would like to do is allow the user to type “Main Street 10” or “10 Main Street” or “Main 10 Street” and get the same results (I can appreciate they will get other results as well). At the minute if I search as “Main Street 10” I don’t get any results. Is this possible with contains?
I guess you could use multiple contains with each word, attached with “and”s, this way, the order of the words doesn’t affect the result.