View Tasks for a Managers Team
I created a Tasks table initially in my app assigning tasks to a Assigned To field that was a List User Type (as there are occassions where I can have more than one assignee on a task). That worked...
Forum Discussion
This part does not make sense to me.
They also recommended a join table between department and Team Member for the data flow (but this does not entirely make sense to me as an employee can only be part of one department.
But it does make sense to have a join table called Resource Assignments between Tasks and Resources to be able to assign multiple staff to a Task. Then the Resource Assignment Join table will know the Department via a lookup from the Team member table.
They also recommended a join table between department and Team Member for the data flow (but this does not entirely make sense to me as an employee can only be part of one department.
But it does make sense to have a join table called Resource Assignments between Tasks and Resources to be able to assign multiple staff to a Task. Then the Resource Assignment Join table will know the Department via a lookup from the Team member table.
Agreed and I am going in that route. So now the question is how do I filter based on the current users department.
So for example Marcy is our Director of Marketing. She is logged in. When she views the report My Team's Tasks she wants to see a list of tasks for her team (Marketing department) sorted and grouped by user (or Employee)
Its that filtering part I am struggling with. Right now I can sort and group by department and use that as a dynamic filter. But I want it to know based on log on
So for example Marcy is our Director of Marketing. She is logged in. When she views the report My Team's Tasks she wants to see a list of tasks for her team (Marketing department) sorted and grouped by user (or Employee)
Its that filtering part I am struggling with. Right now I can sort and group by department and use that as a dynamic filter. But I want it to know based on log on