How to update current sprint team queries in TFS 2010?

Ken Burkhardt picture Ken Burkhardt · Nov 15, 2010 · Viewed 11k times · Source

We are using VS 2010 and TFS 2010 with the Microsoft Scrum Template.

We use the Team Queries for the Current Sprint like the Sprint Backlog query.

The problem is when we move to sprint 2 the "Current Sprint" still points to sprint 1.

Is there a way to to tell TFS that we are now currently in sprint 2 and have the queries use a variable to run against instead of hard-coding the sprint?

For example: If you look at the screen shot below you will notice that the definition of the query uses a variable called "@Project" for the team project. Is there a way to have a variable for the sprint?

alt text

Answer

Ewald Hofman picture Ewald Hofman · Dec 25, 2011

Tom,

What you are asking for is not available in TFS 2010. There are not even dates on the iterations, so TFS does not know what the current iteration is.

In TFS11 (vNext) we have added the dates on the iterations. It now knows in which iteration you are, and this is also reflected on the backlog page in web access. In the preview version that is out now it is however not possible to add a filter clause to your queries to filter on the current iteration (something like @CurrentIteration). We have heard strong feedback to add this in the product before it ships. It is also very high on our wish list, but we need to fix other things first before we can ship.

You can add this request on User Voice. If the idea gets lots of votes it makes it easier to build a case that we need to put this in. But we cannot promise anything.

Ewald - TFS Program Manager