IvanWeiss
6 years agoQrew Captain
Help on a report filtering data based on a "Team"
I have an app with a structure where I have Tasks related to Team Members (A Team member can have many tasks).
In this same App Team Members is related to Departments (A Department can have many team members).
In a report for tasks I need to generate a task listing for all tasks associated with one team. I can do this manually for each team, but I was hoping to do it dynamically based on who is logged on.
So for example, lets say I am part of the Strategic Accounts Team.
I want my report to filter all of the tasks to show all open tasks assigned to anyone on the Strategic Accounts Team.
I know how to dynamically filter by user. But how do I do it by "Team Name" which is a field in the departments table?
Thanks!
------------------------------
Ivan Weiss
------------------------------
In this same App Team Members is related to Departments (A Department can have many team members).
In a report for tasks I need to generate a task listing for all tasks associated with one team. I can do this manually for each team, but I was hoping to do it dynamically based on who is logged on.
So for example, lets say I am part of the Strategic Accounts Team.
I want my report to filter all of the tasks to show all open tasks assigned to anyone on the Strategic Accounts Team.
I know how to dynamically filter by user. But how do I do it by "Team Name" which is a field in the departments table?
Thanks!
------------------------------
Ivan Weiss
------------------------------