[data grid] "singleSelect" column type is not working for columns with multiple values in single columns as comma-separated Values

[sunitchoche333]

Summary

I have a column where multiple values need to be displayed in renderCell and stored as a comma-separated string using valueGetter. However, when I set the column type to singleSelect and provide the values for rendering, filtering does not work as expected.

If I select a single value in the filter, and that value is present in a row with multiple comma-separated values, the row is not returned because it contains additional values alongside the selected one."

Examples

For example, consider a Status column with the following values:

User 1: "Started, Midway"
User 2: "Processed, Completed"

If I set the column type to singleSelect and provide the values to valueOptions for the select dropdown:

Available options in filters dropdown: "Started", "Midway", "Processed", "Completed"

When selecting any of these options, filtering does not work correctly for predefined operators like "is", "is not", and "is any of", because the column contains multiple comma-separated values instead of a single distinct value.

Motivation

No response

Search keywords: singleSelect, column types, multiple values

[michelengelen]

To help us diagnose the issue efficiently, could you provide a stripped-down reproduction test case using the latest version? A live example would be fantastic! ✨

For your convenience, our documentation offers templates and guides on creating targeted examples: Support - Bug reproduction

Just a friendly reminder: clean, functional code with minimal dependencies is most helpful. Complex code can make it tougher to pinpoint the exact issue. Sometimes, simply going through the process of creating a minimal reproduction can even clarify the problem itself!

Thanks for your understanding! 🙇🏼