Dynamic query to share for all the Team Areas dashboards
We would like to create a query to share for all the Team Areas dashboards, it has to use "Team Area" as variable. Idea is to try and use it in the Team Areas dashboard template inside the Process configuration. i.e when the dashboard is created for the first time, the widget should automatically show the respective team work items according to the query provided.
Can someone guide us here? We failed in our initial attempts...
(otherwise current solution would be to create individual query for each teams, and manually configure this in the widget, this really not efficient when you have more than 20 teams...)
Thank you.
One answer
Based on the discussion, I don't think this is currently possible. Unlike a Contributor value (e.g., Created by or Owned by) for which the query mechanism supports a pseudo-variable of "current user", there is no such capability for "current team" or "team for which this dashboard is intended". There is certainly some way in which widgets can be configured for a team during dashboard creation, but since the query mechanism can't use the value this, even if you work out that mechanism and can duplicate it, it's not going to get your query to work.
The closest thing I was able to come up with was telling the query that the Team Area should be selected when the query is run. When adding it to the dashboard, you are asked to choose the team area when you configure the query for the work items widget (it remembers and uses the value thereafter). This might make adding it to multiple dashboards a little less tedious. Maybe.
Comments
sam detweiler
Feb 20 '14, 10:04 a.m.Millard Ellingsworth
FORUM ADMINISTRATOR / JAZZ DEVELOPER Feb 24 '14, 3:12 p.m.Ratheesh Madathil
Feb 24 '14, 12:43 p.m.