Complex and/or chained view filters

[Sashman]

It is often required to have more than one type of filters for a view, like (foo AND bar) OR thud.

As an alternative, it can also be solved by chaining views like VIEW foobar OR thud.

[Kasra]

A few people have requested this, so we’re thinking about it.

In the meantime, you can get around the limitation by creating a formula that evaluates to true (you can use nested ANDs and ORs in formulas), then set the view filter show all records where the formula is true.

[Ben_Orozco]

As stated above and here, some of us have a need for filtering complex boolean operations (like combining Or/And’s, etc.)

I understand this is a complex UI/UX. Some examples I found (for inspiration):

• http://docs.telerik.com/devtools/wpf/controls/raddatafilter/images/RadDataFilter_End_User_Manual_07....

[Casey_Unrein]

This would be nice. Much more flexible and quick than programming a full field for it.

[AntoAni]

To create complex filters like (foo AND bar) OR thud, you can use logical operators in SQL, MongoDB, or JavaScript.

Alternatively, Syncfusion's Data Grid provides powerful filtering options that allow you to create advanced filters easily, saving you development time.