Is there a way to dynamically load child rows when grouping?

We are handling large data, so, when grouping columns, there is substantial loading time as it pulls in all the data at once. Is there a way to just load the parent rows, then when clicking on the chevron to expand, it will dynamically load the child rows?


Frontend: React TS

Backend: C# MVC


3 Replies

AR Aishwarya Rameshbabu Syncfusion Team March 19, 2024 09:46 AM UTC

Hi tjrawlins,


Upon validating your query, it has been observed that you are dealing with a large amount of data and require the child row to be loaded only when the parent row is expanded while using grouped columns. We suggest utilizing the lazyLoadGrouping feature of the Grid component to meet your requirements. For further information on this feature, please refer to the documentation provided below.


Documentation Link: Lazy-load-grouping


If you need any further assistance or have additional questions, please feel free to let us know.



Regards

Aishwarya R




TJ tjrawlins March 19, 2024 02:03 PM UTC

Hi Aishwarya,


Thanks for the quick response. The issue we run into with using lazy loading is that load times become longer and longer the more we scroll down. I believe this is happening because lazy loading is re-loading the previously loaded children rows as well as the new set of children with each load. Eventually, the load time becomes extremely long. Are there any other options?



AR Aishwarya Rameshbabu Syncfusion Team March 21, 2024 03:08 AM UTC

Hi tjrawlins,


Upon reviewing your inquiry, it appears that you are experiencing a loading issue with lazyLoadGrouping while scrolling through the records. Before proceeding with a solution, we kindly request the following details to further validate the issue and to provide an optimal resolution:

1. Kindly specify the type of data binding being utilized in the Grid - whether it is Remote or Local data.

2. If remote data is being used, please specify the type of adaptor along with the code lines defining the DataManager.

3. Please provide the complete Grid rendering code along with any customized functions.

4. If feasible, kindly share a simple sample for issue replication along with a video demonstration.

5. Please specify the version of the Syncfusion package being utilized.



Regards

Aishwarya R


Loader.
Up arrow icon