Search More than One Property

Includes the ability to search on more than one property

I guess the usual and expected behaviour of all search boxes across the internet (and all local search boxes on all devices I have seen) would be searching by all data available.

Like, if there is list of records from a collection, that comes with search, then expected behaviour is that it would search everything in that collection, all fields available, not just one.

Not sure if Algolia would be a great way to implement this

Elastic Search may be suitable… GitHub - elastic/elasticsearch: Free and Open Source, Distributed, RESTful Search Engine

Highly desired! :+1:


Originally posted by: gregoryalbritton+canny@gmail.com

Please consider algolia for search components too, they have a react-native lib

Yes, this is great!

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.

we need same SQL LIKE
name like’%textname%’

100% need this feature, filtering and search is critical to any data driven app.

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!
    Thanks,

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 :wink: (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?

Kijana Garrett: I got the data from here: https://thesneakerdatabase.com/

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”

Really need a customizable search feature

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.