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
Millard Ellingsworth (2.5k●1●24●31)
| answered Feb 24 '14, 3:33 p.m.
FORUM ADMINISTRATOR / JAZZ DEVELOPER
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 Millard,
Searching through the existing work items for "query pseudo variable" I found some interesting, likely related work items that seem to have been implemented (you may be able to suss something from these):
and these two that seem to ask for the same functionality you are looking for:
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
I am not aware of any way to query dashboards or team areas. You can query workitems. and GET their team areas. but I don't think that is useful.. as the current gadgets don't have much extensibility
There are widgets that autopopulate on a new team dashboard that set the team area. I think one of the challenges in your situation is that to look for work items for a team, you are really querying against Filed Against (a work item category) and it is possible to associate more than one work item category with a team. So there is no way to automatically create an association when the dashboard is created.
I dont think that associating more than one work item category with a team area could lead to any kind of trouble.
Because the basic query function still supports to query for work items against a team area.
Only challenge is to customize this query to a scope of filtering it for that "Team Area"