Hi ,
I have a data in hierarchical structure ex: parent --> children --> grandchildren Usecase: Get parent docs by adding filter on children and grand children or Get grand children docs by adding filters on parent and children To accommodate this use case i have flattened the docs by adding a reference (parent) in the children and similarly (parent and children) in grandchildren doc. And used graph to query join the data using from/to fields. But this gets complicated as we add filter with AND and OR conditions. Any other approach which can solve these kind of use cases . Regards sam
