Filters on both parent and child

I'm trying to model a parent-child relationship using the join datatype. For example, department - employee. When I query is it possible to specify a filter on both parent and child at the same time? For example, department_location = California and employee_position = Manager? If yes, what would the syntax be?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.