TFS 2008、Conchango Scrum For Team Systems 和工作项查询
我们在 TFS 2008 中使用 Scrum 团队系统的第一个版本。我想做的是编写一个查询来获取当前活动冲刺中的所有冲刺积压项目。我想使用 @Today 参数周围的冲刺开始和结束日期来获取列表。
像这样：
Team Project = @Project
AND Sprint Start <= @Today
AND Sprint End >= @Today
此查询仅返回 Sprint。我想要所有冲刺积压项目。我几乎需要能够进行子查询
Team Project = @Project
AND Sprint Number IN (Sprint Start <= @Today AND Sprint End >= @Today)
有人有什么想法吗？现在我真的很
Team Project = @Project
AND Sprint Number <= 12
讨厌每次开始新的冲刺时都必须更改所有查询中的数字的想法。
谢谢
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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我自己一直在尝试寻找更优雅的解决方案。一种复杂的方法是向 Sprint Backlog 项目类型添加一个名为“CurrentSprintEndDate”的自定义字段，并通过自定义事件处理程序更新它，当项目的迭代路径字段发生更改时，该事件处理程序将更改该字段。您可以像上面那样对该字段编写类似的查询，例如“CurrentSprintEndDate > @Today”。
但对于看似简单的事情来说，这需要做很多工作。
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.