Property

• Client-Side

  • data, the array of data items the data source contains. The data source will wrap those items as kendo.data.ObservableObject or kendo.data.Model.

  • aggregate

  aggregate: [{ field: 'title', aggregate: 'count' }]
  
  // How to add aggregation field
  // 1. Add aggregrate on the dataSource
   aggregate: [
     { field: "SubTotal", aggregate: "sum" }
   ],
  // 2. Add footerTemplate 
   columns: [
         { field: "SubTotal", title: "Amount", format: "{0:c}", footerTemplate: "#= kendo.toString(sum, 'C') #" }
  ]
  

  • filter

    // simple object
    filter: { field: 'title', operator: 'startswith', value: 'Shawshank' }
    // ...or array...
    filter: [{field: 'year', operator: 'eq', value: '1998'}, {field: ...
    // ...or configurable object...
    filter:{
      logic: "or",
      filters: [
    { field: 'title', operator: 'startswith', value: 'Shawshank' }]
    }
  
    /* How to filter a data source */
    // define a filter object
    var detail_filter = { logic: "and", filters: [] };
  
    // add filters
    detail_filter.filters.push({ field: "status", operator: "eq",    
            value: status });
   detail_filter.filters.push({ field: "cedantId", operator: "eq",    
      value:      
      $("#txtCedantCompany").data("kendoDropDownList").value() });
  
     // apply filter to DataSource
  
     detailSource.filter(detail_filter);
  

  • group

    group: { field: 'year', dir: 'asc' }
    

  • sort

    sort: { field: 'title', dir: 'desc' }
    

  • paging

    // remove paging 
    var dataSource = $("#inventoryItemsDetail").data("kendoGrid").dataSource,
    total = dataSource.total();
    
    dataSource.pageSize(total);
    
    $("#inventoryItemsDetail").data("kendoGrid").refresh();
    $("#inventoryItemsDetail").data("kendoGrid").bind("dataBound", function () {
                this.pager.element.hide();
    });
    
    // end of remove paging
    

• Server-Side

  • serverAggregates
  • serverFiltering
  • serverGrouping
  • serverSorting
  • serverPaging