Multi select in grid filter template?

[Nicholas]

Hi,

I'm attempting to make a grid with an Excel-like inline column filter that displays distinct values within the data set and allows the user to select multiple values.

I'm using a custom control based off kendoMultiSelect to do this, but noticed that neither it nor the out-of-the-box multi select work properly in a filter template -- it seems that the filter expression it generates ends up containing "[Object object]" for the value instead of an actual value since the control's value() function returns an array.

Just wanted to confirm that this is expected behavior and that there's no work around before I work on a more complex solution (probably hooking the Kendo functions used to generate the filter exp.). I threw up a quick jsfiddle showing the issue here with some static test data (the multi select is on the Ship Name column): http://jsfiddle.net/K63cE/

Thanks,
Nick Blakely

[Alexander Popov]

Hi Nick,

Yes, I am afraid this is the expected behavior. Making a filter menu that utilizes the MultiSelect widget would require a custom solution that relies on the Grid's filterMenuInit event. Once the event is triggered you could add the widget and the custom logic that modifies the filter. I would recommend checking this example, where similar behavior is illustrated.

Regards,
Alexander Popov
Telerik

[Nicholas]

Thanks, I'll do that.

[Mark]

Hi Alex,

Just wondering if it's possible to maintain the selections in the multiselect. In the example posted, only the first item is retained.

Regards,
Mark

[Alexander Popov]

Hi Mark,

I would recommend checking this updated example, where the element's data-bind attribute is removed, so the selection persists.

Regards,
Alexander Popov
Telerik

 

 

[Mark]

Hi Alex

Thanks very much for that, did the trick.

Regards,
Mark

[Alain]

Hi Alex,

The values in this example persist when element's data-bind attribute is removed.

However, I try to use the filters values with server paging but I can't retrieve the values for the server?

I retrieve the filters values like this and I send it to the server with the paging information.

var gridFilters = $("#grid").data("kendoGrid").dataSource.filter().filters;

The selection persist and the gridFilters is correct when the filters are applied but is empty as soon as the page change.

Any idea?

Thanks
Alain

[Alexander Popov]

Hello Alain,

I am not entirely sure what is causing this behavior. This scenario is not supported out of the box and implementing it requires a custom solution that is beyond the scope of our support services.

Regards,
Alexander Popov
Telerik

 

 

[Victor]

I implemented a solution that involved creating a custom widget.  Its seems to be working.  Getting the custom widget to work in conjunction with the built-in filtering mechanism was tricky.  Hopefully, the ability to filter columns with a checkbox list is added as a built-in feature.  You can see my implementation here:

http://jsfiddle.net/victordscott/5kbfY/3/

[Mark]

[quote]Alexander Popov said:Hi Mark,

I would recommend checking this updated example, where the element's data-bind attribute is removed, so the selection persists.

Regards,
Alexander Popov
Telerik

 

 

[/quote]

Hi Alex,

It seems that with data-bind removed, then the filter cannot apply simultaneously with other filters. However, with data-bind present, the selection does not persist between searches.
Is there a way to achieve both persistent search term AND filtering multiple columns simultaneously?

Regards
Mark

[Alexander Popov]

Hi Mark,

Although not supported out of the box, this could be achieved by getting the current filter, then merging it with the one specified in MultiSelect widget and applying it again.

Regards,
Alexander Popov
Telerik

 

 

[Greg]

I have same issue. Can you please share solution.

[Victor]

I think that this feature was implemented in the last release.  See demo here:

http://demos.telerik.com/kendo-ui/grid/filter-multi-checkboxes

 

[Greg]

Thanks for your reply.
Actually It would be difficult for the user to filter with check box when we have large result set.
So i want to implement filter with mutliselect.

Please provide me some solution.

[Alexander Popov]

Hi Greg,

As previously mentioned, using a MultiSelect widget in the filter menu is not supported. Implementing this feature would require a solution that is outside the scope of our support services.

Regards,
Alexander Popov
Telerik