Search More than One Property
What you need my friend is fuzzy search, why don't you check out the API I've been working on with built-in fuzzy search just for Adalo.
marked this post as
Searching more than one property is possible with Adalo's AND/OR logic. If there are other search features that are important, please create new individual requests for those features.
Josh Johnson: Hi Josh, the solution you mentioned is entirely meant for something else. What we needed and mentioned below as well is as follows,
Like stored data is “I love my pizza”
But if user type “Pizza love”, then still search engine should be able to search “I love my pizza” record. Where "I love my pizza" is written in a single property.
Josh Johnson: So I would consider this feature still incomplete and not delivered.
K&A Solutions: that's fuzzy search. The title of this card is "Search more than one property." I would encourage you to submit "fuzzy search" as a separate request. Thanks!
Josh Johnson: Google became the biggest company just because of its search capability (Fuzzy Search) ,, but why Adalo did not realize its importance yet?
Josh Johnson: Plus I have already created a feature request for "Fuzzy Search". Appreciate if Adalo can prioritize this most compeling feature.
Link is as follows,
Josh Johnson: wow
Really need a customizable search feature
This is the most wanted search feature. It would allow users to search in any sequence.
Like stored data is “I love my pizza”
But if user type “Pizza love”, then still search engine should be able to search “I love my pizza”
I wanted to call out that with OR Logic filtering, you should be able to search more than one property now. Are there other critical features here that are missing? Thanks!
Josh Johnson: Something that would be great would be to be able to search by keywords and not by exact string of words. Let's take an example with my sneakers app:
- If a user wants to find, let’s say the "Nike SB Dunk Low Safari" he has to type at least 2 or 3 words of the full name in the correct order (ex: “dunk low safari”). But if he types “dunk safari” the search engine won’t return any result, because the user has not typed the exact string of words.
That’s why I would like to find a way to search by keywords that would allow users to find shoes in a more intuitive way. Pretty sure it would help many other users to improve their search feature as well!
Régis Boussari: Try using "Contains" in your search filter. That should get you partial matching like you're looking for.
Josh Johnson: This is already the property I used on my search engine. Unfortunately, since there are 5000+ various designs of Dunks, when you type "dunk", you get as many results ;) (you can check here: https://web.plgrnd.app/)
This is why I would love to have to have a search engine that would filter by keywords and not by strings of words.
I think it would be "only certain results match a keyword" when this keyword is in the search input.
> Basically in my app, when I type "dunk safari", I would love to have the "Nike SB Dunk Low Safari" appear as a result.
But since I did not type the words in the exact order I get no results. To have this sneaker appear in the results, I need to type the keywords in the same order as in this sneaker name ("dunk low safari" works, for example).
Régis Boussari: which database are you using to store your sneakers info?
Régis Boussari: good point
100% need this feature, filtering and search is critical to any data driven app.
Merged in a post:
Searching by keywords and not by exact string of words
Currently, with the "contains" filter on the search input, users have to search for an exact string of words to find the correct item that matches their request.
It would be more intuitive to allow users to search by keywords.
we need same SQL LIKE
Alberto Vargas Zubieta
Keyword search is the most intuitive way for our users to search using inputs, we cannot expect our user to know exactly how our records are written. This problem is specially evident in large databases.