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.