Is there a way to use variables in JQL?

[Rob Horan]

I would like to create a set of queries for a dashboard that I can re-use from version to version such that I can use a variable in the JQL.  This would allow me to make a single change which would affect all the filters used on that dashboard.  The only other option is to manually edit every bloody filter.

[Renjith Pillai]

Since Rapid Board uses story points, I guess a Hour Burn Down is currently not available. If you are using GreenHopper planning (not using Rapid Board) this is possible. But in that case, it is per project basis.

Also please check the Time Tracking/User Workload/Version Workload reports, whether it gives the information you are looking for. Most of them are again per project basis. The 'User Workload' can use a Filter and it can span across projects and you can tune the filter to include what kind of issues and versions you are looking for in the report.

http://confluence.atlassian.com/display/JIRA/Version+Workload+Report

http://confluence.atlassian.com/display/JIRA/User+Workload+Report

http://confluence.atlassian.com/display/JIRA/Time+Tracking+Report

[Anthony Newnam]

Renjith,

Thanks for your response. I've taken a look at those reports before, but as you mention, most of the reports are specific to projects. The user report gives an overall number, but that isn't quite the level of detail I'm looking for.

What I would like is for when my manager says "what is your team working on?", I could show him a breakdown of what my team is planning to do and when it will get done.

The Planning Board in JIRA sort of accomplishes this; however, it still requires you to look per version. It wouldn't nearly as quick to get the same kind of data.

[Renjith Pillai]

The answer "what is your team working on?", wont it be sufficient to have a filter created with the appropriate projects and assignees, and customize the column order to include 'Remaining Estimate'? This could be added to a Dashboards, along with a few gadgets showing statistics across projects,components.versions and assignees. I guess the Manager should get satisfied with this.

[Anthony Newnam]

That would show me the backlog, but it won't show me when an issue will be completed unless I add up the days manually. It is very difficult to quickly gleem when any given issue is estimated to be completed.

I still think having a Gantt chart would be helpful, but I am leaning towards only using Fix Version to indicate priority.