Question

We are using the first version of Scrum for team system in TFS 2008. What I m trying to do is write a query to get all sprint backlog items in the current active sprint. I d like to use the sprint start and end dates around the @Today param to get the list.

something like this:

Team Project = @Project
AND Sprint Start <= @Today
AND Sprint End >= @Today

This query returns only the Sprint. I want all the sprint backlog items. I almost need to be able to do a subquery

Team Project = @Project
AND Sprint Number IN (Sprint Start <= @Today AND Sprint End >= @Today)

Anyone have any ideas? Right now I just have

Team Project = @Project
AND Sprint Number <= 12

and I really hate the idea of having to change the number across all my queries every time we start a new sprint.

Thanks

Answer 1

I have been trying to find a more elegant solution myself. One convulted way is to add a custom field to the Sprint Backlog Item type called "CurrentSprintEndDate", and update it thru a custom event handler that will change this field when the item s iteration path field changes. The you could write similar queries as you were doing above agains that field such as "CurrentSprintEndDate > @Today".

But that is a lot fo work for something that would seemingly be simple.

友情链接