Unplanned
Last Updated: 19 Nov 2021 13:48 by ADMIN
David
Created on: 12 Nov 2021 22:31
Category: Grid
Type: Feature Request
7
Allow filtering on a grid column containing an array

It would be great if we could use the built in column filtering on columns containing arrays.

Or at the very least have a workaround (which I have not been able to find on the site).

I understand that the current implementation relies on the data being flat, but support for the following situation would be great:

- Grid cell is bound to an array and a template is used to display character delimited data (ie. One, two, three, four).

- Column filtering will display multi select options for the data.

 

1 comment
ADMIN
Eyup
Posted on: 19 Nov 2021 13:48

Hi David,

 

Thank you logging this suggestion. This seems like a nice idea and I hope it will gather traction for a built-in offering.

Regarding multi-value or array filtering, you have several current options:

1. Multi-checkbox filtering:
https://demos.telerik.com/kendo-ui/grid/filter-multi-checkboxes

2. Template:
- https://docs.telerik.com/kendo-ui/knowledge-base/multiselect-used-for-column-filtering
- https://docs.telerik.com/kendo-ui/knowledge-base/filter-grid-with-multi-select-widget

3. Custom filter function to handle the array logic:

dataSource.filter({
    field: "FieldName",
    operator: function(item, value){
        //implement your logic
    },
    value: 12
})
- https://www.telerik.com/forums/custom-filtering-7b617857877c#2095150
- https://stackoverflow.com/questions/19033065/kendo-grid-filtering-on-an-array-object/19055051

To summarize, I am afraid the Grid does not provide a built-in way to achieve this requirement, but it provides Templates and filter function which can be used to accomplish it.

I hope this information is helpful.

Regards,
Eyup
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.