How to create view of self-recursive relationship table?

Hello All,

I have a recursive relationship table of item_group data which have foreign key to refer to another record as parent_id to create subgroup and hierachy. For example, car is a subgroup of vehicle group. My question is how to create view in UX to show only highest level group first, then if click to any parent group will show its subgroup then finally show the table of item in the subgroup.

Thank you

So if you create a table view and set it to group by vehicle and then by car. This should give you what you want

3 Likes