Grouping Error with Custom Binding

[Uwe Hein]

Hi everibody,

  I built a simple grid with custom binding according to your documentation. Trying to group a column produces an error (see attached sample). I am using Win 10 prof Ver. 1909 in German VS Community 16.5.5 and Syncfusion 18.1.0.52.

Your grid sample produced by template editor with similar data (no custom binding) is working OK.

  regards

    Uwe

Attachment: GridGroupingError_d12e47fe.zip

[Renjith Singh Rajendran]

Hi Uwe, 

Greetings from Syncfusion support. 

We have discussed about this topic in the below thread. So, we suggest you to refer the below thread for more details regarding this topic. 

https://www.syncfusion.com/forums/153319/blazor-grid-grouping-error-when-using-sfdatamanager-adaptors-iqueryable-18-1-44 

As discussed in above link, we suggests you to handle the Grouping action in Grid as like the below code to overcome the problem you are facing. The below solution is discussed in the updates of the above thread. 

 

                     public override object Read(DataManagerRequest dm, string key = null)                  

                      { 

                             System.Diagnostics.Debug.WriteLine("ReadAsync"); 

 

                             IEnumerable<Order> DataSource = Orders; 

                             DataResult DataObject = new DataResult(); 

                             ... 

                             if (dm.Group != null) 

                             { 

                                    IEnumerable ResultData = Enumerable.Empty<Order>(); 

 

                                    foreach (var group in dm.Group) 

                                    { 

                                           ResultData = DataUtil.Group<Order>(DataSource, group, dm.Aggregates, 0, dm.GroupByFormatter); 

                                    } 

                                    DataObject.Result = ResultData; 

                                    DataObject.Count = count; 

                                    return dm.RequiresCounts ? DataObject : (object)ResultData; 

                             } 

                             return dm.RequiresCounts ? new DataResult() { Result = DataSource, Count = count } : (object)DataSource; 

                      } 

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran 

[Uwe Hein]

Hi Renjith,

   sorry for not looking deep enough in the threads.

Problem solved.

Maybe you should mention this in your documentation, because I got the source code from there.

   Thank you

       regards

          Uwe

[Rahul Narayanasamy]

Hi Uwe, 

Thanks for the update. 

We have logged a documentation task for this and this will be included in any of our upcoming release. 

Regards, 

Rahul