Virtual Scrolling, Group Load On Demand with ExpandoObject

[Johan]

The docs/demos use the classic list of Employee class as data source, but what if the data source is an ExpandoObject instead? I've tried a few things, but the expanded group only fetches one row, and sometimes no rows at all. I'd love to hear if anyone has got this working?

[Tsvetomir]

Hello Johan,

To gather more information on how to bind the Grid component to the Expando object, I recommend referring to our KB article - Bind Grid to Expando Object. The article, also how to use such a Grid configuration with the Load on Demand Groups functionality. 

I hope the provided information and examples in the article help you to move forward with your requirements.

Regards,
Tsvetomir
Progress Telerik

[Johan]

I am well aware of those articles, but when I try load groups on demand with a virtual grid but with ExpandoObject, incorrect number of items gets loaded. 

That's why I asked for an example.

[Tsvetomir]

Thank you for coming back with feedback.

After further observation of the described Grid configuration, I can inform you that the behavior is a known bug, that has already been reported in our feedback portal: LoadGroupsOnDemand does not let you group with an ExpandoObject as data source. I voted for the item to raise its priority. 

In the interim, a possible workarounds are suggested in the item. We apologize for any trouble caused.

Additionally, you can subscribe to the linked item to get email notification for further status updates.

[Johan]

Ok, that explains. Thanks for getting back on this. I'll look at the linked item. Unfortunately I cannot use a "real" class/object because the result may have one or many columns depending on a search results.

[Tsvetomir]

Thank you Johan for sharing more information about your scenario.

For the time being, the other alternative is to remove the LoadGroupsOnDemand functionality and use regular paging so you can still have grouping.