Enable sorting, filtering and grouping for a column bound to an object


Product Version 2018.3.1017
Product Grid for ProgressĀ® Kendo UIĀ®


How can I enable sorting, filtering and grouping for a column which is bound to an object in the Kendo UI Grid?


To enable sorting, filtering and grouping for a column which is bound to an object, bind to column to a field of the object and the editor to the object itself.

    <script src="https://demos.telerik.com/kendo-ui/content/shared/js/products.js"></script>
    <div id="example">
      <div id="grid"></div>


        $(document).ready(function () {
          var dataSource = new kendo.data.DataSource({
            pageSize: 20,
            data: products,
            autoSync: true,
            schema: {
              model: {
                id: "ProductID",
                fields: {
                  ProductID: { editable: false, nullable: true },
                  ProductName: { validation: { required: true } },
                  Category: { defaultValue: { CategoryID: 1, CategoryName: "Beverages"} },
                  UnitPrice: { type: "number", validation: { required: true, min: 1} }

            dataSource: dataSource,
            pageable: true,
            height: 550,
            toolbar: ["create"],
            columns: [
              { field:"ProductName",title:"Product Name" },
              { field: "Category.CategoryName", title: "Category", width: "180px", editor: categoryDropDownEditor },
              { field: "UnitPrice", title:"Unit Price", format: "{0:c}", width: "130px" },
              { command: "destroy", title: " ", width: "150px" }],
            editable: true,

        function categoryDropDownEditor(container, options) {
          $('<input required name="Category"/>')
            autoBind: false,
            dataTextField: "CategoryName",
            dataValueField: "CategoryID",
            dataSource: {
              type: "odata",
              transport: {
                read: "https://demos.telerik.com/kendo-ui/service/Northwind.svc/Categories"

In this article
Not finding the help you need? Improve this article