is it possible to have Grid/ google-like filtering in the MVC Kendo UI?

[Sang]

We want to build a grid having google like filtering, is it possible and what is the best way to wrap the code around the current kendo ui grid to accomplish this?  TIA.
e.g.
ASP.NET Ajax Grid Google Like Filtering

[Petur Subev]

Hi Sang,

Yes such behavior could be achieved with the Kendo Grid. You need to create different ComboBoxes in each of the column header templates and attach Change handlers to the comboboxes.
For example:

columns.Bound("ProductName").Sortable(false).HeaderTemplate(@<text>
                      @(Html.Kendo().ComboBox().Name("cProducts")//you can use ajax binding if you preffer
                          //.DataSource(ds=>ds.Read(rea=>rea.Action("GetProducts","Home")))
                          .BindTo(new List<string>{"Chang","test2"}) //or direct populate on the server
                          .Events(ev=>ev.Change("onComboProductChange"))
                      )
                  </text>);

And the following Change handler:

<script type="text/javascript">
    function onComboProductChange(e) {
        if (this.value()) {
            $('#Grid').data('kendoGrid').dataSource.filter(
             { field: "ProductName", operator: "startswith", value: this.value() }
            );
        } else {
            $('#Grid').data('kendoGrid').dataSource.filter([])
        }
    }
</script>

I hope this helps.

Regards,
Petur Subev
the Telerik team

[Sang]

Hi Petur,
Thanks for the information.  If we generate our own header, it means that we can no longer use Kendo grid header to handle our sorting correct? 

[Petur Subev]

Hello Sang,

Yes I intentionally disabled the sorting of the column because the other way the ComboBox is unable to open.

Regards,
Petur Subev
the Telerik team

[Tito]

Hi Petur,

there is a small problem with this implementation, it doesn't consider the other filters, so if I select the productName filter it give me the filter only by the productName, disconsidering the other columns. I am trying to consider the other columns as well, do you have any idea?

Best Regards.
Tito Morais