How to get data for each detail grid when expanded

[Mongonv]

We are trying to use the grid with embedded detail grid when the use opens the selected line, but want to load just the detail data for the opened master record that is related to the detail. 

So when the user opens master line 1, it loads the data for detail of line 1, then when they open master line 2, it loads the data for that master's detail grid.

I can find how to filter all the details for all masters, but if we have hundreds of masters with thousands of related detail records, we don't want to load all those. 

Is there a way to assign a different data set to each opened detail grid?

Thanks for any ideas

[Alexander Popov]

Hi Mongonv,

Indeed, setting a filter is the recommended approach shown in our Hierarchy Grid demo. The child Grids in the demo also use server paging and filtering, further reducing the amount of data that has to be loaded remotely. I am not sure I understand how this is different from the behavior you described. Would you please elaborate?

Regards,
Alexander Popov
Telerik

 

 

[Mongonv]

Hey Alexander,

Here is a scenario we are trying to find the best option for:

Using a hierarchy grid setup with the detail section having a tabstrip with 3-4 other grids within the detail section and the user may only want to look at 2-3 of the master/detail sets of all the available master records. 

The master grid has say 500-1000 (potentially 20,000-150,000 master records on some sites) records and each detail tabstrip grid has 10-50 records per detail grid.

This would mean we would have to load the initial 500-1000 master records and then another 15,000 - 150,000 records for all the detail grids within the tabstrip in the detail section.

We are trying to figure out what is the best approach with the kendo environment.  We really like the hierarchy model of UI, but need to figure out how to reduce the amount of data that gets loaded at one time to properly utilize that model.

Let me know if that needs more clarification.

Thanks for you input,

Ed

[Alexander Popov]

Hi Ed,

Basically, the child Grids won't be initialized until the detail row is expanded. You can combine this with a lower pageSize of the master Grid's dataSource and serverPaging. This will guarantee that data is requested only when required, thus minimizing the network overhead.

Regards,
Alexander Popov
Telerik