OData $select & $expand

2 posts, 0 answers
  1. redshift20
    redshift20 avatar
    5 posts
    Member since:
    Feb 2013

    Posted 28 Nov 2017 Link to this post

    I'm trying to create a master/detail page for an Accounts table in our database.  Our Accounts table has a few hundred fields in it, so the master grid should only show a short summary of a few pertinent fields for the user to identify which account they want to look at in detail.  I would also like to display fields from a few joined tables in the master grid as well.

    We are using an Web API & OData source.  Instead of creating new endpoints to return the summary data I need, can we utilize the OData $select & $expand options with the Grid?

    I might be missing something simple here, but if you have any suggestions or tutorials, I would appreciate it.


  2. Marin Bratanov
    Marin Bratanov avatar
    5611 posts

    Posted 01 Dec 2017 Link to this post


    The closest option I can offer is that you bind the grid manually after invoking the desired request: http://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/client-side/programmatic/defaultcs.aspx. Perhaps this will allow you to use tools like jQuery to get the necessary URLs, parse their data and provide it to RadGrid.

    If this is not an option for you, I would suggest you consider exposing endpoints that fetch the concrete data/objects you need as it is done in one of the grids here: http://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/client-side/declarative/defaultcs.aspx.


    Marin Bratanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top