I'm trying to write a bit complicated (at least for me) query in Insight and hope someone can help me
I have an Employee object type that have the Name and the Department number of the Employee
I also have a Department object type with Department number and Manager Name
Same Manager can manage a few Departments
I want to write a query that would show the current user (Manager) the list of all Employees he manages. In other words a list of Employees that have the department number that belongs to this manager