Possibility of grouping, filtering and excel exporting of a column with an array of strings

[Tobias]

Hello,

the datasource of my grid have an array of strings which i can successfully display with the valueAccessor option

The data has this format: 

{

     ...
     propertyWithArray: ['A', 'B', 'C']

}

With the valueAccessor I can display the values in a column e.g. comma separated like 'A, B, C'  

But: If I group and filter by this column, I can only filter by the complete string which ist displayed in the grid.

I want to group and filter by each entry itself. If an item includes a, b, it should be filtered by A or B or C with checkboxes,
The grouping should be grouped in the same way. If I have an item with two or more items in the array. The groups should be one group for each item
A: items...
B: items...

C: items...
It one item is in group A and B, it should be appear in both groups

This groups should appear in the same way when the grid is exported to excel.

Thanks in advance for your help
Tobias A

[Manivel Sellamuthu]

Hi Tobias, 

Greetings from Syncfusion support. 

By analyzing your query, we understand that you having an array of value in the grid column and you need to perform and group action on this column. 

By default, the EJ2 Grid column only supports number, string, date, dateTime, Boolean, checkbox type values, and which is not supports array type value. Refer to the below documentation. 

 

UG: https://ej2.syncfusion.com/angular/documentation/grid/columns/#column-type 

 

We can show an array of values in the Grid column (using the valueAccessor API and by iterating each array value in columnTemplate feature). But this is used only for the display purpose. We cannot perform Grid actions like Filtering, Searching, Grouping, Sorting, etc., to this column. This is the default behavior of EJ2 Grid. 

Please let us know, if you need further assistance. 

Regards, 

Manivel 

[Tobias]

Hi Manivel,

thank you for the information but it's a pity that that won't work.

Maye be will add such a feature in a future release.

Have a nice weekend.

Tobias

[Manivel Sellamuthu]

Hi Tobias, 

Thanks for your update. 

We would like to inform you that it is not feasible to achieve your requirement with our current architecture. 

Please let us know, if you need further assistance. 

Regards, 

Manivel