How to get data for each detail grid when expanded

4 posts, 0 answers
  1. Mongonv
    Mongonv avatar
    10 posts
    Member since:
    Nov 2005

    Posted 20 Jul 2015 Link to this post

    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

  2. Alexander Popov
    Admin
    Alexander Popov avatar
    1416 posts

    Posted 22 Jul 2015 Link to this post

    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
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
  4. Mongonv
    Mongonv avatar
    10 posts
    Member since:
    Nov 2005

    Posted 22 Jul 2015 in reply to Alexander Popov Link to this post

    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

  5. Alexander Popov
    Admin
    Alexander Popov avatar
    1416 posts

    Posted 24 Jul 2015 Link to this post

    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
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top
Kendo UI is VS 2017 Ready