Server Grouping with virtualisation

[Geetha]

Hello All, I followed this example https://demos.telerik.com/aspnet-mvc/grid/server-grouppaging-virtualization to implement in my project, however i am getting error while doing grouping with mutiple columns, i tried searching in the forms for a solution but no luck. 

This is my Code below

Html.Kendo().Grid<Project.ViewModels.ListViewModel>()
    .Name("GridName")
    .Columns(columns =>
    {
        columns.Select().Width(50).HtmlAttributes(new { @class = "checkbox-align" }).HeaderHtmlAttributes(new { @class = "checkbox-align" });
        columns.Bound(p => p.Company);
        columns.Bound(p => p.Country);
        columns.Bound(p => p.City);
        columns.Bound(p => p.CodeSociete);
    })
    .ToolBar(toolbar =>
    {
        toolbar.Create();

    })
    .ColumnMenu(col => col.Filterable(true))
    .Height(550)
    .Sortable(sortable=>sortable.Enabled(true))
    .Navigatable()
    .Resizable(r => r.Columns(true))
    .Groupable()
    .Filterable(filterable => filterable
        .Enabled(true)
        .Extra(true)
        .Operators(operators => operators
            .ForString(str => str.Clear()
                .StartsWith("Starts with")
                .IsEqualTo("Is equal to")
                .IsNotEqualTo("Is not equal to")
            ))
        )
    .Scrollable(scrollable => scrollable.Virtual(true))
    .Events(events => events.DataBound("onDataBound"))
    .DataSource(dataSource => dataSource
    .Ajax()
    .Events(events =>
        events.Error("error_handler")
    )
    .Model(model =>
    {
        model.Id(p => p.ID);
    })
    .GroupPaging(true)
    .PageSize(50)
    .Read("DetailProducts_Read", "List")
    )
)

 

My Controller class ListController.cs

[HttpPost]

        public ActionResult DetailProducts_Read([DataSourceRequest]DataSourceRequest request)

        {

 

                IEnumerable<List_Entity> list = myService.getAll(out totalRecords, this.UserId.ToString());

                listDB = list

                    .Select(f => new ListViewModel()

                    {

                        ID = f.ID,

                        Company= f.Company,

                        Country= f.Country,

                        City= f.City,

                        CodeSociete= f.CodeSociete

,

                    }).ToList();

 

        DataSourceResult result = listDB.ToDataSourceResult(request);

               

                result.Total = (int)totalRecords;

                return new JsonResult() { Data = result, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue };

    }

 

When i run the application virtualisation,sorting,filtering,paging works perfectly without grouping, when i try to group with first colum drag and drop all the events work perfectly, but when i try to drag second column to grouping i get the following error (errorDebug.png) and in the browser console window i have this error

Uncaught TypeError: Cannot read property 'length' of undefined
    at Function.map (jquery-1.10.2.js:789)
    at init.groups (kendo.aspnetmvc.js:212)
    at proxy (jquery-1.10.2.js:841)
    at init.groups (kendo.all.js:6508)
    at init._readData (kendo.all.js:7371)
    at init.success (kendo.all.js:7575)
    at success (kendo.all.js:7527)
    at Object.n.success (kendo.all.js:6404)
    at fire (jquery-1.10.2.js:3062)
    at Object.fireWith [as resolveWith] (jquery-1.10.2.js:3174)

 

Could you please help me to resolve this issue?

 

 

 

[Geetha]

Any help please?

[Tsvetomir]

Hi Geetha,

I have investigated the provided code snippets and it appears that they are set up correctly except for the ActionMethod. I suppose that the JsonResult is formatting the response in a way that the grid cannot parse correctly. 

Is it possible for you to alternate it as shown here:

var jsonResult = Json(result, JsonRequestBehavior.AllowGet);
  jsonResult.MaxJsonLength = int.MaxValue;
  return jsonResult;

Also, the multi-level grouping is supposed to be working correctly as our demo utilizes 2 groups by design:

https://demos.telerik.com/aspnet-mvc/grid/server-grouppaging-virtualization

In case the issue persists, let me know.

 

Kind regards,
Tsvetomir
Progress Telerik

[Geetha]

Hello Tsvetomir, Thank you for your reply, actually i tried with this and i am still getting the same error while grouping  with multiple fields. 

In the example above provided, the datasaource is using custom binding and i am using Ajax. how is it different? can this be a problem for grouping?

[Geetha]

Hello, by the way the myService.getAll method gets the data from SQL server through Dapper interface, we are not using the EntityFramework, is there any problem in conversion to ViewModel?

[Geetha]

Hello i resolved the problem, set ServerOperation(false), i refered this article 

https://www.telerik.com/forums/mvc-grid-bound-to-dynamic-data-only-sends-empty-object-to-controller