Search More than One Property
complete
n
nadav
Has anyone found a solution to this?
Josh Johnson
nadav you can use OR logic in the list filter to check if the value of the input matches a number of different properties. See attached screenshot where the filter looks to see if the user's name OR email match the input.
n
nadav
Josh JohnsonMy problem is that I have a large database and if the users do not write the search in chronological order, it finds nothing.
It is really my dream that this matter will be resolved
Tareef Roustom
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.
K&A Solutions
Tareef Roustom: Yes surely I need Fuzzy Search ,,, but how would it work with Fuzzy search ,, can you help me understand more ,, like
1- how it would work end to end
2- how much it would cost
Josh Johnson
complete
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.
K&A Solutions
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.
K&A Solutions
Josh Johnson: So I would consider this feature still incomplete and not delivered.
Josh Johnson
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!
K&A Solutions
Josh Johnson: Google became the biggest company just because of its search capability (Fuzzy Search) ,, but why Adalo did not realize its importance yet?
K&A Solutions
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,
Devin Rossey
Josh Johnson: wow
Devin Rossey
K&A Solutions: you want a search index is what is sounds like.
n
nadav
Josh JohnsonIs there a solution to this issue?
A
Adalo User
Really need a customizable search feature
K&A Solutions
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”
Josh Johnson
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!
Régis Boussari
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!
Thanks,
Josh Johnson
Régis Boussari: Try using "Contains" in your search filter. That should get you partial matching like you're looking for.
Régis Boussari
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.
Régis Boussari
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).
Kijana Garrett
Régis Boussari: which database are you using to store your sneakers info?
Régis Boussari
Kijana Garrett: I got the data from here: https://thesneakerdatabase.com/
Devin Rossey
Régis Boussari: good point
n
nadav
Devin RosseyThis is exactly the problem I talked to you about in another post if you remember
Mischelle
100% need this feature, filtering and search is critical to any data driven app.
Josh Johnson
Josh Johnson
Merged in a post:
Searching by keywords and not by exact string of words
Régis Boussari
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.
Ahmed Alnaqa
we need same SQL LIKE
name like'%textname%'
Load More
→