FlexGrid serverside grouping

FlexGrid serverside grouping

Posted by: m-miertschink on 14 September 2017, 12:10 pm EST

• 

  m-miertschink

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:10 pm EST

  Hi,
  
  is it possible to do grouping of data serverside?
  
  We have huge datasets where we need to do some analysis on. ANd if this is always based on the current page it is a big issue for our application.
  
  Any ideas?

  Thanks

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 12:10 pm EST

  Hi,
  
  Currently, this feature is not available. If you would like to use, you can add this feature using ServerCollectionView class. You can also accomplish this using this on client. For this, you need to disable server side paging.

  We have also created an enhancement request for the same with tracking id 276474. If it is found feasible, it will be included in the future releases.

  Thanks,
  
  Manish Kumar Gupta

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 8 January 2018, 8:13 am EST

  Hi,
  
  We are sorry for the late reply.

  Here is the reply from the development team.

  Unfortunately, OData does not currently support grouping. MS has indicated they planned to add this support, and even approved a standard format for it, but as far as I know it never got implemented.

  http://www.odata.org/blog/odata-v4-extensions-aggregation/

  Even if they did approve this, the grouping they mention is similar to the GROUPBY clause in SQL. It is supposed to aggregate groups of records and replace some variables with aggregates, Although this is certainly a useful feature, it is not compatible with the grouping used in the CollectionView class, which creates hierartchical structures (CollectionView groups contain child records, they don’t aggregate them).

  I suppose if/when this support is added, it will be relatively easy to use it via standard REST interfaces, independently of Wijmo’s CollectionView.

  ~Manish