I'm currently using RadzenDataGrid to display large datasets, and it's working excellently with the LoadData approach. I'm able to leverage the grid's API information (ordering, sorting, pagination, and filtering) to build optimized database queries on the server side.
Now I need to add grouping functionality, but it must also be handled at the database level to maintain performance. However, I haven't found any examples in the documentation showing how to implement server-side grouping similar to the other features.
From what I can see, the grouping feature appears to be designed primarily for in-memory data. My question is: does the grid expose grouping information through the LoadData API (similar to how it provides sorting, filtering, etc.) that I could use to construct the appropriate SQL queries?
If so, could you point me to documentation or provide an example of how to access and utilize this grouping metadata to implement server-side grouping?
Thanks in advance!