The default grid filters are OK, but we'd really like to be able to customize them. For example, I want to be able to set a simple filter for a column that consists of a drop down list of all items that exist in that column. Excel does this quite well. Is it possible to add out own filtering UI?
It seems like you could do that by adding a dropdown control (kendo ui, of course) to the column header cell and binding a datasource to it populated by the same values that would populate that column for the grid. Then add a change handler to the dropdown control that calls filter on the grid. I've found the filter functionality for datasources to be very flexible.
How exactly does the change handler call filter on the grid? I'm trying the exact same thing you mentioned, but cannot figure out how to set the grid's filter and force the grid to refresh with the new filter data.