1. Home
  2. Forum
  3. Blazor
  4. Grouping doesn't work with Paging - Only groups data on the current page.

Grouping doesn't work with Paging - Only groups data on the current page.

Good evening,


When I use Grouping and Paging on a Grid, only data on the current page is grouped. For example 5 rows could be grouped on page 1, but 3 more again on page 2. I'd like to group by a column on the entire data source.

Please could someone show me an example in Blazor equivalent to this, from Asp.Net Core - https://ej2.syncfusion.com/aspnetcore/documentation/grid/how-to/grouped-row-page-size/





Thank you,


Tom

11 Replies
VN Vignesh Natarajan Syncfusion Team February 25, 2020 12:10 PM UTC

Hi Tom,  
 
Greetings from Syncfusion support.  
 
Query: “Please could someone show me an example in Blazor equivalent to this, from Asp.Net Core” 
 
Currently we are validating your query. We will update you the further details by 27th February 2020. Till then we appreciate your patience.  
 
Regards, 
Vignesh Natarajan. 


TO Tom March 2, 2020 10:06 AM UTC

Hi Vignesh,

Please could I have an update on this? I can't see an obvious way to use grouping in the EjsGrid besides loading all the data into one page.





Thank you,

Tom

VN Vignesh Natarajan Syncfusion Team March 4, 2020 10:03 AM UTC

Hi Tom,  

We regret for the inconvenience caused. 

In our current architecture, initially we will sort the entire data source and then grouping is performed in current page sorted data. So that current page records alone grouped and displayed.  

We have tried to achieve your requirement using Custom Adaptor feature where all operations will be perform externally. But we face some issues and complexities in achieving the requirement using Custom Adaptor. We need some more time to analyze the issue. So we will update you the further details by 6th March 2020.  

Regards, 
Vignesh Natarajan. 


TO Tom March 12, 2020 04:52 PM UTC

Hi Vignesh,

Could I have an update on this please? 

Is the only way for grouping to display complete groups to load all the data into one page? (Virtualisation isn't an option in my case as I need to programatically select rows, and I'm dealing with around 50,000 rows)




Many thanks,

Tom



VN Vignesh Natarajan Syncfusion Team March 16, 2020 06:42 AM UTC

Hi Tom,  

We deeply regret for the delay in responding to your query.  

Query: “For example 5 rows could be grouped on page 1, but 3 more again on page 2. I'd like to group by a column on the entire data source.” 

By default on Grouping with paging feature, aggregated information and total items will be displayed based on the current page records alone. Grid will not consider other page records while grouping. So we can get aggregated details and total items count based on the entire data source instead of current page by enabling the Disable page wise aggregate feature.  

This feature will help users to display only the aggregates value and total count of the grouping based on the entire data source. Refer the below screenshot for your reference.  

 

So kindly share the details whether above feature will matches your requirement or not. Based on your update we will update you the further details regarding this.  
  
Regards, 
Vignesh Natarajan. 


TO Tom March 17, 2020 05:35 PM UTC

Hi Vignesh,

No problem, your support has been great.


The DisablePageWiseAggregates would be ideal, except it also doesn't work (only applies to current page too) - Please see here for thread regarding this:

https://www.syncfusion.com/forums/148731/grid-aggregate-sum-only-current-page-data-not-all-data

I'm testing this on the very latest version 17.4.0.55, and still finding it shows both groups and count for the current page only. Once this has been fixed, as stated in the above thread, that will be enough for users to tell that the rest of their data is on the next page.



Thanks for your time,

Tom

VN Vignesh Natarajan Syncfusion Team March 18, 2020 10:52 AM UTC

Hi Tom,  
 
Thanks for the update.  
 
Query: “as stated in the above thread, that will be enough for users to tell that the rest of their data is on the next page” 
 
We have added this feature request to our database. At the planning stage for every release cycle, we review all open features and identify features for implementation based on specific parameters including product vision, technological feasibility, and customer interest. It will be included in any of our upcoming release 
 
You can also communicate with us regarding the open features any time using our Feature Report page 
 
 
We will let you know when this feature is implemented. Till then we appreciate your patience 
 
Regards, 
Vignesh Natarajan. 


TS Thorsten Sommer October 13, 2021 10:26 AM UTC

What about equal support for your javascript-grid?


Regards,

Thorsten Sommer


VN Vignesh Natarajan Syncfusion Team October 14, 2021 03:48 AM UTC

Hi Thorsten, 

Thanks for contacting Syncfusion support. 

EJ2 JavaScript Grid has DisablePageWiseAggegate support to display total aggregated count in Grouped details based on entire datasource. We have already documented this topic in our ug documentation and it can be referred from below  


Please get back to us if you have further queries. 

Regards, 
Vignesh Natarajan  


VA Varun replied to Vignesh Natarajan July 15, 2022 03:37 PM UTC

This link doesn't work
No Content.
Kindly update the content.
Thank you


NP Naveen Palanivel Syncfusion Team July 18, 2022 05:03 PM UTC

Hi Varun,


Greetings from the Syncfusion support.


Recently we have revamped the structure of our documentation. So We suggest to refer the below page for the same topic in our documentation.


Sample link: https://ej2.syncfusion.com/javascript/documentation/grid/grouping/grouping/#group-with-paging


Please get back to us if you need further assistance


Regards,

Naveen Palanivel


Loader.
Up arrow icon