cancel
Showing results for 
Search instead for 
Did you mean: 

MetaTree - Filter based on parent and parent's parent

Contributor

MetaTree - Filter based on parent and parent's parent

Hi, 

 

I'm trying to build a metatree that looks like this in "Mega" terms

 

Org-Unit

        Objective

               Project

 

Is there a way to make the Project list exclusive to the Org-Unit selected as "grand-parent". In the queries, I'm able to refer to the parent using the &name parameter.

Example: 

Select [Project] Where [Achieved Objective] = &"name"

 

The problem is that I get all projects related to the objective, whatever the parent org-unit. I would like to filter the Org-Unit as well so that the list would represent only the projects of the Org-Unit for the selected objective. 

 

If an objective is shared between 2 org-units, I would like to get the following: 

Org-Unit A

        Objective A

               Project A

Org-Unit  B

        Objective A

               Project B

 

I don't want to "hardcode" the Org-Unit because there are many and names may change over time. 

 

Any way you think of doing this?

 

Thanks! 

Tags (2)