[data grid] Improve filtering logic and UI

[michelengelen]

Summary

While reviewing issue #14869, I found the proposed idea to be a valuable enhancement for data grid filtering overall.

The proposal outlines three distinct features, which should be addressed separately:

1. Support for Filtering Groups with Combined Logical Operators [data grid] Support filter group / query builder #4217
   This feature would enable more complex filtering scenarios by allowing logical groupings of filters. For example, in a car rental database, an accountant might need to determine if a van is available in New York between 06/18/2025 and 06/25/2025, or if a bus is available in New York between 06/12/2025 and 06/25/2025. This could be achieved by structuring the search as follows:

   city = 'NY' AND ((type = 'van' AND available = [06-18-2025..06-25-2025]) OR (type = 'bus' AND available = [06-12-2025..06-25-2025]))

2. Implement a Text Field for Query-based Search
   This feature would allow users to input raw queries similar to the one above. This would require developing parsing logic to interpret and execute the query.
   The textfield could also implement a autocomplete on the specific value grabbed from the data as suggestions. A great example is the new issue search textfield from the github issue facelift beta:

3. Enhance the Filtering Panel
   The filtering panel should be updated to incorporate the new grouping capabilities and support mixed logical operators.

Given the frequency of requests for improved filtering functionality, it would be worthwhile to explore these enhancements in detail.

Related issues:

• [data grid] Excel-like filters behavior #670
• [data grid] Excel column filters #3571
• [RFC] Filtering interfaces #3719
• [data grid] Support filter group / query builder #4217
• [data grid] Add more filter operators #13610
• [data grid] Ability to combine by multiple logic operators and group them #14869

Examples

The recent facelift of github issue search (in public beta) is a great example for this:
https://github.com/orgs/community/discussions/139934