Extending Column Grouping and Filtering Across Full Data Set in Syncfusion Data Grid (Desktop Version)

[srimathi]

Hi,
I have implemented the Load More feature to efficiently manage large data sets in the Syncfusion data grid for the desktop version. However, when applying column grouping, the filter functionality only affects the currently displayed records and does not apply to the entire data grid source. I need to extend the column grouping and filtering to work across the full data set, not just the visible portion.

Could you please assist me with this?

Regards,

Srimathi

[Abinesh Palanisamy]

Hi srimathi,

Based on the details provided, you're using the 'load more' feature to efficiently manage large datasets. Initially, a set number of rows are loaded into the DataGrid. When you reach the bottom of the vertical scroll and tap the 'load more' button, additional rows from the remaining collection are converted and added to the DataGrid. Sorting, filtering, and grouping are applied only to the rows added to DataSource.rows. Data that hasn't been converted into rows and added to DataSource.rows isn't considered for these operations. This behavior is expected with the 'load more' feature in the DataGrid.

As an alternative to the 'load more' feature, you can use pagination. The DataGrid supports interactive data manipulation using the SfDataPager control, which loads data in segments, making it easier to handle large volumes of data. For more information, refer to the User Guide and KB.

UG links - Paging   & sort and filter all rows with pagination

KB links - create paginated Flutter DataTable   &  Filter or Sort All Rows

Regards,

Abinesh P

[srimathi]

Hi Abinesh ,

Thanks for your reply. 

I've implemented pagination in the Syncfusion data grid to handle large datasets more efficiently. However, I'm encountering an issue with column grouping. Even after enabling both pagination and grouping, the data appears but then disappears in the blink of an eye.

I'd like to achieve a scenario where the entire dataset is grouped first, regardless of pagination. Then, pagination should be applied to the grouped results, allowing users to navigate through the grouped records in a paginated manner.

For instance, if I have 10000 records and apply a grouping, I expect the grid to group all 10000 records initially. Pagination would then be used to display the grouped records in batches, ensuring that any remaining records within a group are displayed on the subsequent page before moving to the next group. This way, users can seamlessly scroll through the grouped data without any interruptions.

[Abinesh Palanisamy]

Hi srimathi,

We have checked your query at our end, and we are able to replicate that issue at our end, especially when grouping all the rows instead of just those on the current page with SfDataGrid.rowsPerPage enabled. We have considered this as a  bug and logged a bug report regarding this in our feedback portal. We will fix the reported issue and include the changes in our upcoming weekly patch release, which is expected to be rolled out on October 22, 2024. We will let you know once released, and we appreciate your patience until then. You can also track the status of the bug using the feedback link below.
 

Feedback Link: 62002

Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization. 

Regards,

Abinesh P

[srimathi]

Hi Abinesh,

Thank you for your prompt response and for confirming the issue. I appreciate that you’ve logged it as a bug and provided the expected release timeline.

I will track the status using the feedback link and look forward to the fix in the October 22 patch release. I understand that the inclusion may depend on other factors, and I appreciate your efforts in resolving this.

Thanks again for your support.

Best regards,
Srimathi

[Abinesh Palanisamy]

Hi srimathi,

We are glad to inform you that the reported problem has been resolved on our end. Therefore, kindly update SfDataGrid to the latest version(27.1.55).

Root cause :  When using SfDataGrid.rowsPerPage for paging, we split the rows on the source side and adjust them accordingly for pagination. In this process, the _handleListener method clears the displayElements, causing all grouped rows to be removed when NotifyListener is called. As a result, the DataGridRows appear empty in the view.

If you have any further queries, please don't hesitate to reach out. We are more than happy to assist you.

Regards,

Abinesh P