How do I retrieve hierarchical data using aggregates, such as a category tree with subcategories and product
Hi Manisha,
you should have an entity for "Category" with a parent-child relationship, and another entity for "Product" related to categories .
Create an aggregate that retrieves "Category" data and includes a self-join to establish the parent-child relationship.
Include an aggregate within the first aggregate to retrieve related products for each category.
on your UI, use nested List Records widgets to display categories and their corresponding products.
Use indentation or expand/collapse features to show the hierarchical structure
Hope it helps
Arun
Hi Arun
Thanks for information let me implement according to your solution
Sure let me know if need any help.
Regards