AND/OR relation between filters and an option to use brackets

[Emoke Mozesne Csikos]

Hi All,

I am not sure this has been asked:
I want to be able to define AND/OR relation between filters when creating views. I also want to use brackets to set up such relations between "groups" of filters.

E.g., I want entries to be displayed in the view that fulfill the following:
(criterion1 OR criterion2) AND criterion3

Now, using any or all, I can set up only these:
using any: criterion1 OR criterion2 OR criterion3
using all: criterion1 AND criterion2 AND criterion3

Is there a trick I am not aware of? Or is this functionality planned to be developed?
Thanks!

[Martin Vali]

I have used filters in filters to solve the problem.

Filter 3 = filter 2 and Filter 1

Filter 4 = Filter 3 or filter 5

[Patrick Keller]

Can I see a video snippet of an example of how you use this implementation?

[Martin Vali]

My bad - I misunderstood - I have not tried that in databases

[Jason Hills]

This would be the most amazing thing.


I'm using databases for a lot of use cases that were probably not envisioned, such as building a security-permissions model for our software systems. I'm doing that because it offers a very easy to use relational database that I can customize and build the permissions groups. It would be that much better if I could apply basic logic to the filters.

Hey, any app builders out there.

Get on this.