We have had a request from a client to show our data somewhat differently from our standard layout. I'd like to know if this would be possible by only modifying some UI grid code, not the underlying data model.

So we have a data set with two tables. Call it table A and table B. There is a one to many relation established between A and B so that an item in A can have multiple items in B. table A have a column GROUP which we group by default. table B has a column, let's call it FIELD. :)

This works great. The grid shows all the elements in A with an expander next to each element to see its associated elements from B.

Now the client comes to us and asks, instead of grouping by GROUP can we group by FIELD. So, they are essentially asking us to invert the model. Is this possible to do via the grid? If an item in A has multiple child items in B, there should be multiple instances of A in the view.

Best
-Szymon