Server side sorting doesn't render as expeceted

1 posts, 0 answers
  1. Patric Svensson
    Patric Svensson avatar
    14 posts
    Member since:
    Nov 2006

    Posted 13 Feb 2013 Link to this post

    Edit: Thought this was a ticket but realized I was wrong and have now added a support ticket for this issue.

    Hi, 

    We have a grid that we would like to populate with server side sorted information. So what we did was this:
    @(Html.Kendo().Grid<MyProject.ViewModels.Calculation.WorkGridItem>()
          .Name("grid")
          .BindTo(Model.WorkGrid.WorkGridItems)
          .Columns(c =>
                       {
                           c.Bound(i => i.Identifier).Title("Id");
                           c.Bound(i => i.Name).Title("Namn");
                           c.Bound(i => i.City).Title("Stad");
     
                           c.Bound(i => i.Status).Title("Status");
                           c.Bound(i => i.StartDate).Title("Start");
                           c.Bound(i => i.EndDate).Title("Slut");
                           c.Bound(i => i.Created).Title("Skapad");
                           c.Bound(i => i.SigningDate).Title("Signatur");
                       })
                .ClientDetailTemplateId("expandedRowTemplate")
                .Events(l => l.DetailInit("OnLoadDetail"))
                .Events(ev => ev.DetailExpand("detailExpand"))
                .Pageable(x =>
                        {
                            x.PageSizes(new int[] { 50, 100, 200 });
                            x.Refresh(true);
                        })
            .Sortable(x => x.Enabled(true))
            .DataSource(ds => ds.
                                Ajax()
                                .ServerOperation(true)
                                .Read(read => read
                                                  .Action("ReadGridItems", "Calculations",
                                                          new
                                                              {
                                                                  selectedTab = Model.Tabs.SelectedTab().Value,
                                                                  gridType = Model.PageHeaderSearch.SelectedSearchType,
                                                                  searchString = Model.PageHeaderSearch.SearchWord,
                                                                   
                                                              })
                                                  .Type(HttpVerbs.Post)
                                )
                                .PageSize(50)
    We then sort the data, and returns the data source and I can see it being sorted the way I want it to. However, when the data is redered in the grid it is all messed up. 

    When sorting desc on one of the columns, the date would look like this:

    28.02.2013
    28.02.2013
    28.02.2013
    28.02.2013
    28.02.2013
    26.02.2013
    25.03.2013
    25.02.2014
    25.02.2013


    Why is this? By setting ServerOperation to true, whould that not then let me do the sorting on the server side and then let me just render the data? 

    Any thought on this?


Back to Top