是否可以在特定时间范围内查询TFS以查找从挂起到活动的任务？(Is it possible to query TFS for tasks that went from Pending to Active within a certain timeframe?)

我正试图找到一种方法来跟踪我的团队在过去一周内开始执行哪些任务的状态，以及他们关闭了哪些任务。 看起来必须在MS Project中设置开始日期和结束日期字段，我们不使用它们。 我希望有一种方法可以根据状态转换日期编写查询，但我没有看到。 有没有办法获得管理层想要的数据？

I'm trying to find a way to track the status of which tasks my team has started in the past week, and also which ones they've closed. It looks like the Start Date and the End Date fields both have to be set in MS Project, which we don't use. I was hoping there would be a way to write a query based on state transition dates, but I'm not seeing one. Is there any way of getting the data my management wants?

最满意答案

是的，使用ASOF，您可以查看特定日期的查询状态。 然后简单地将它们与'now'或另一个ASOF进行比较，以便检测您之后的转换。 检查这个霍夫曼邮报。

Yes it is, with ASOF you can view the state of a query on a certain date.Then simply compare them to 'now' or another ASOF in order to detect the transition you 're after.Check also this Hofman-post.

是否可以在特定时间范围内查询TFS以查找从挂起到活动的任务？(Is it possible to query TFS for tasks that went from Pending to Active within a certain timeframe?)

我正试图找到一种方法来跟踪我的团队在过去一周内开始执行哪些任务的状态，以及他们关闭了哪些任务。 看起来必须在MS Project中设置开始日期和结束日期字段，我们不使用它们。 我希望有一种方法可以根据状态转换日期编写查询，但我没有看到。 有没有办法获得管理层想要的数据？

I'm trying to find a way to track the status of which tasks my team has started in the past week, and also which ones they've closed. It looks like the Start Date and the End Date fields both have to be set in MS Project, which we don't use. I was hoping there would be a way to write a query based on state transition dates, but I'm not seeing one. Is there any way of getting the data my management wants?

最满意答案

是的，使用ASOF，您可以查看特定日期的查询状态。 然后简单地将它们与'now'或另一个ASOF进行比较，以便检测您之后的转换。 检查这个霍夫曼邮报。

Yes it is, with ASOF you can view the state of a query on a certain date.Then simply compare them to 'now' or another ASOF in order to detect the transition you 're after.Check also this Hofman-post.