[data grid] Support filter group / query builder

[oliviertassinari]

Summary 💡

Have the ability to have "and"/"or" filter at the same time.

Benchmarks

• https://www.notion.so/, UX: feels great.

https://developers.notion.com/reference/post-database-query

• https://github.com/ukrbublik/react-awesome-query-builder
• https://www.telerik.com/kendo-react-ui/components/datatools/
• https://airtable.com/, UX: feels good.

• https://app.ashbyhq.com/, UX: feels awful.

• https://www.ag-grid.com/javascript-data-grid/filter-advanced/

Motivation 🔦

It's meant to solve advanced filtering use cases, similar to what you can do with SQL queries. This feature is not available in Excel.

[m4theushw]

#2437 requested the same feature. At that time, the user needed to filter rows that had one value of a list of values, so the isAnyOf operator was created. This operator can be used to create the query from the second screenshot (fields between OR are the same). However, isAnyOf can't be used in cases where the fields differ (first screenshot).

[flaviendelangle]

Related to #3719

I would distinguish two things:

1. Improve the filtering engine to support models with nested operators
2. Improve the UI to support these new models

The part 1 can be done without doing the part 2 if we want to allow users to build there UI for a time and then build our own.

[Pustelto]

Hi, it would be great if the engine could support group filters. We will need this feature as well, but we are ok with building our own UI (we already plan to do it anyway). So if at least the point No. 1 could be implemented, that would be a huge help.

Improve the filtering engine to support models with nested operators

Thanks a lot 🙏

[vlad-healthhelper]

Hi everyone, we are having the same issue. We are using the Data Grid Pro and we need to be able to combine ANDs and ORs while filtering. Here is an example of the filter we need: Person name is John AND Person height is more than 6 feet AND (dob is empty OR dob is before 1/1/1990).

Data Grid is awesome! Thank you all for what you put together!

[russjman]

Hi everyone, we are having the same issue. We are using the Data Grid Pro and we need to be able to combine ANDs and ORs while filtering. Here is an example of the filter we need: Person name is John AND Person height is more than 6 feet AND (dob is empty OR dob is before 1/1/1990).

Data Grid is awesome! Thank you all for what you put together!

We are also needing this type of advanced filtering( nested/grouped ). Any idea if this is being worked on or considered? Our team has a pro license

[agrauch]

We would also like to have the ability to group filters

[Mengying1717]

Hi Everyone, our team has a pro license and we have the same issue here as well. Group filter will be very helpful. Would like to know is this being considered? Thanks!

[muckinger]

We are also Pro-Users and urgently need the ability to group filters. Any plans or Updates? I think this is a very common usecase. Thx!

[hdale94]

Also looking for this feature. When you have several groups of columns using the same headerNames, the filter and column visibility menus become a confusing mess.

Hope this gets implemented ASAP, thanks!

[subashthiru3]

Hi,
When I given add filter multiple times in MUI Data grid (and & or) was disabled can explain the reason and if any possible to enable.
Note: I'M using data grid Pro version

[shotokai]

My team are also Pro users and we really need this. Recently switched from another paid solution where this was a feature.