[Bug] when combining AND OR criteria in advanced filtering, ANDs are not working #8571
Description
Bug Description
Current state of advanced filtering is not properly applying all filtering criterias.
See the following video for demonstration : https://www.youtube.com/watch?v=BwcVOjSKIBo&t=138s
How to Reproduce
apply a combination of AND OR filtering criteria where you know a shortlist of results should appear.
notice that what is displays does not match filtering criteria
Expected Behavior
filtering criteria should be 100% respected
Operating System
windows
AppFlowy Version(s)
0.11.4
Screenshots
No response
Additional Context
No response