Skip to main content

Complex and/or chained view filters

  • November 15, 2015
  • 4 replies
  • 26 views

Forum|alt.badge.img+4

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.

4 replies

Forum|alt.badge.img+4
  • Inspiring
  • November 18, 2015

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.


Forum|alt.badge.img+13
  • Known Participant
  • March 15, 2017

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):


Forum|alt.badge.img+4
  • New Participant
  • June 6, 2019

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


Forum|alt.badge.img
  • New Participant
  • June 27, 2024

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.