Lazy load subgroups when GroupBy

[Praveen]

Hi,

Looks like, using the VirtualQueryableCollectionView, it is possible to lazy load the data if it is flat, but it is not possible if the data is displayed hierarchically. That is, using VirtualQueryableCollectionView, if GroupBy is done for single\multiple columns, the grouping is done only of the initial few records, obviously, as only few records are loaded initially by the VirtualQueryableCollectionView.

If there are multiple groupings then there is a hierarchy, and one can drill down subgroups step by step. I wanted to know if there is a way with GridView to lazily load the subgroup items.

Any suggestions will be helpful.

thanks

[Vladimir Stoyanov]

Hello Praveen,

I am afraid that, if you need to allow grouping of your data, you will need to go with another type of collection as grouping is not supported when using the VirtualQueryableCollectionView since grouping implies that all the data should be loaded beforehand, which breaks the conception of this mechanism. 

Instead, you can use the QueryableCollectionView class and provide an IQueryable as its source collection so that all operations will be executed directly on the server using the query provider.

I hope that using the QueryableCollectionView would work for you.

Regards,
Vladimir Stoyanov
Progress Telerik

[Praveen]

Hi Vladimir,

I have used the IQueryable as

var dataView = new QueryableCollectionView(dataRows.AsQueryable().ToIList());
grid.ItemsSource = dataView;

where dataRows is "IEnumerable<DataRow>".

I am able to somehow perform sorting\filtering using VirtualQueryableCollectionView, but grouping seems difficult.  

Is there a way with Telerik grids and classes to do groupings and perform lazy loading of grouped items?

thanks,

Bhushan

[Vladimir Stoyanov]

Hello Praveen,

I am afraid that lazy loading of grouped items is not possible. To reiterate, in order for the data to be grouped, it needs to be fetched first. This would be the case for QueryableCollectionView as well as for the VirtualQueryableCollectionView which does not support grouping altogether.

I hope that this clarifies things. If you have any additional questions or concerns, please let me know.

Regards,
Vladimir Stoyanov
Progress Telerik