Grid custom checkbox filtering

[RAKOTONINDRINA MAMY]

Hi team,

I have a type that has a property user, wich is a list of users linked to it. 

I list all values of that type into a grid.

The content of the user column is the concatenation of all users converted to strings as shown below :

The filter dialog applyed to the user column automatically displays all values according to the content of the cells as shown below :

I would like to know if there is an option to display each user individually for each checkbox in the filter dialog like below :

Thanks in advance,

Mamy

[Sujith Kumar Rajkumar]

Hi Mamy, 

 

Greetings from Syncfusion support. 

 

We checked your query and would like to let you know that the Grid’s filtering functionality works on basis of comparing the filtered data with the corresponding column field data in the underlying data source which is bound to the grid. So even if individual columns values are split and displayed in the checkbox filter, the filtering will be performed based on the column value present in the data source. This is the Grid’s default behavior. 

 

From this – “The content of the user column is the concatenation of all users converted to strings”, please let us know if the column data(‘User’ column) is present as the concatenated string in the underlying data source or if different column values are concatenated to display it. 

 

Let us know if you have any concerns. 

 

Regards, 

Sujith R 

[RAKOTONINDRINA MAMY]

Hello,

Thank you for your answer.

"please let us know if the column data(‘User’ column) is present as the concatenated string in the underlying data source or if different column values are concatenated to display it". => The User column is present as concatenated string in the data source.

Regards,

Mamy

[Sujith Kumar Rajkumar]

Hi Mamy, 

 

Thanks for sharing the details. 

 

As mentioned in our last update, the filtering operation in the Grid compares filtered data with the underlying data source. Since the concatenated values are present in the column data even if the column values are split and displayed in the checkbox filter, all the filtering cases cannot be handled properly with customization. Because of this, the column data cannot be split and filtered. 

 

Let us know if you have any concerns. 

 

Regards, 

Sujith R