[data grid] add a "does not contain" filter

[benjimac93]

Summary

Similar to the 'contains' filter on Data Grid, we've had quite a few customers request an option for "does not contain"

Examples

No response

Motivation

No response

Search keywords: Filter contains
Order ID: 83665

[michelengelen]

Hey @benjimac93
You can easily add your own filter to the columns by following this section in the docs: Create a custom operator

I do agree that we could possibly add a reversed contains filter.
Would there be any objections handling this as a feature request @mui/xgrid ?

[benjimac93]

not at all :)

[cherniavskii]

Yes, we miss some options for excluding the data, e.g. "does not contain" and "does not equal" 👍🏻

[KaralyosBela]

Hey @cherniavskii create a custom operator this works fine if you use it with the filter button, or with the column filter. I noticed that if you try to use it with the header filters enabled, it crashes. If you edit this example: create a custom operator to use a DataGridPro or Premium and add the headerFilters prop to it, you will get this error: Error: Missing translation for key headerFilterOperatorAbove. Any idea how to fix this?

[cherniavskii]

We need to do some benchmarks here. Potentially, almost all of the filter operators can be negated, but should we add a new one for each of those? It doesn't seem right. How about adding a negation modifier that can be applied to any filter operator? E.g. a "Not" checkbox that would negate the filter operation.

[github-actions]

This issue has been closed. If you have a similar problem but not exactly the same, please open a new issue.
Now, if you have additional information related to this issue or things that could help future readers, feel free to leave a comment.

Note

We value your feedback @benjimac93! How was your experience with our support team?
If you could spare a moment, we'd love to hear your thoughts in this brief Support Satisfaction survey. Your insights help us improve!