Having the ability to due multiple searches with filtering is a crucial assets to useful apps. Getting results based on a series of combinations of data is essential.
A or B = not not (A or B) = not (not A and not B) so they will need to make it group able.
this is very important!! would solve many problems for querying data. I always come across the lack of OU during the development of the application logic.
This is the one thing holding my app back. If anyone knows a solution, let me know 
Chris Duncan: Sadly, the best I’ve been able to do is put multiple lists on the same screen and show/hide them based on another input. See the attached screenshot. The “Search By” dropdown list changes which list and search box are actually displayed. My biggest complaint here is if I change what is displayed in the list details, I have to change it in 3 places. It would all be so much easier if the list filter allowed “Name contains X” OR “Order Number contains X”.
This enhancement would also be extremely useful when configuring visibility logic
Chris Duncan: Also, I came across this “hack” to combine multiple database properties for a search: https://youtu.be/ddf3dx-bIhs
Not having this is a major stumbling block.
Working with “real” developpers, there’s always hesitation about low code platforms. Having to go explain that I can’t do ‘or’ logic isn’t something I’m looking forward to.
‘And’ is technically possible in filters.
Both need to be brought to conditional visibility
Hello guys! I’ve created a new component with implementation of many logical functions in Adalo, maybe it will be useful for you.
Currently, all our filtering logic is AND. In this cycle, we’re going to add OR functionality as well so you can build more complex filters.
Josh Johnson: Will this include display conditions too? So display if x or y? And will it support multiple conditions e.g. X and Y or Z?
Paul H: It will support things like (X and Y) or Z, but for now we’re going to start with list filtering. Visibility is definitely one area we want to expand it to in a later launch though!
Any update on the release date? Josh Johnson
This will help in building powerful filters.
Abhishek Singh: We’re progressing well! You should have something to try out in January
Josh Johnson: This will be great and it is a major limitation currently so looking forward to it
Josh Johnson: Hello, so no “if” condition is scheduled with the “or” improvement of list ? It’s tricky when you want an user to pick some criteria to filter but he doesn’t set all of them (ex : color, condition, brand..)
Josh Johnson: Any news on progress?
Oleksandr Kyrylov: SOOOOOOO close. We’re doing QA on the final two cards
Launched! 
You can now use both AND & OR functions when filtering lists and dropdowns! Watch this video to learn more. https://www.youtube.com/watch?v=lY_ZJgKwyIM
Josh Johnson: Nice one Josh! Keep up the good work 