Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1715
Grouping by relation's column
posted

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

Parents
No Data
Reply Children
No Data