Hello
I have a tree collection for products and have another table where services are associated with each child product. I would like to have a UI view that shows all services that roll-up to the parent products. Is this natively possible within the collections and UI? Or, do I need to do something like develop a SQL tables that does the iterative joins of services per product level and then use the filed in that table to show the roll-ups?
- product 1
- product 1.1
- service 1.1.1
- product 1.2
- service 1.2.1
- service 1.2.2
- product 1.1
In UI view of table, I would like for the services to rollup the parent:
| product | services
| product 1 | service 1.1.1, service 1.2.1, service 1.2.2 ← serivce rollup –
| product 1.1 | service 1.1.1
| product 1.2 | service 1.2.1, service 1.2.2
What I have right now is:
product | services
| product 1 | ← No service rollup to parent product 1 –
| product 1.1 | service 1.1.1
| product 1.2 | service 1.2.1, service 1.2.2
Thanks!