如何编写值是字段值的 TFS 2010 工作项查询子句？
我认为这个问题可能是由于缺乏知识而产生的，但是我们开始......
我正在尝试编写一个新的团队查询（使用团队的新查询选项explorer，在 VS 2010）我想要的相当简单；本质上是[已完成的工作]值超过[原始估计]字段值的工作项列表。换句话说，WI 超出了最初的估计。
VS 2010 视图似乎没有选项来显示在后台生成的 WIQL，因此我必须通过 VS 2010 UI 描述我已经完成/正在尝试执行的操作。
条款的开头相当标准；
团队项目 = @Project
工作项类型 = 任务
并且 State = [Any]
我添加了一个 caluse（以删除任何没有估计的工作项）
和原始估计<> ”
我认为下一步就是简单化本身；添加一个类似于
的子句 和已完成的工作>原始估计
但无论我如何尝试在用户界面的值字段中写入“原始估计”（如原始估计、[原始估计]等）其他变体）到目前为止，我得到的只是一行指示输入字符串的格式不正确。
这可能吗？我本以为会支持与另一个 WI 字段的值进行简单比较，是吗？如果可能的话，他**的语法是什么？
谢谢。
更新
我查看了任务模板，并确认原始估计和剩余工作都是双精度的，并且具有以下全名（应该是相关的）
Friendly Name Type Ref Name
Original Estimate Double Microsoft.VSTS.Scheduling.OriginalEstimate
Remaining Work Double Microsoft.VSTS.Scheduling.RemainingWork
I think this question may be spawned from lack of knowledge, but here we go...
I am trying to write a new team query (using the new query option of team explorer, in VS 2010) what I want is fairly simple; essentially a list of work items whos [Completed Work] value exceeds the [Original Estimate] field value. In other words WIs that have exceeded their original estimates.
The VS 2010 view does not seem to have an option to show the WIQL being generated under the hood, so I'll have to describe what I have done/am trying to do via the VS 2010 UI.
Clauses are fairly standard to start;
Team Project = @Project
And Work Item type = Task
And State = [Any]
I have added a caluse (to remove any work items without an estimate)
And Orignial Estimate <> ''
I thought the next step would be simplicity itself; adding a clause along the lines of
And Completed Work > Original Estimate
But no matter how I try to write "Original Estimate" in the value filed of the UI (as Original Estimate, [Original Estimate] and many other variations) to date all I get is a line indicating a that Input string was not in a correct format.
Is this possible? I would have thought simple comparisons to the value of another WI field would be supported, are they? If it is possible what the he** is the syntax?
Thanks.
Update
I had a look at the Task template and confirmed that both Original Estimate and Remaining Work are doubles and have the following full names (should that be relivant)
Friendly Name Type Ref Name
Original Estimate Double Microsoft.VSTS.Scheduling.OriginalEstimate
Remaining Work Double Microsoft.VSTS.Scheduling.RemainingWork
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您只需要 >= [Field] 运算符而不是 >= 运算符：
You simply need the >= [Field] operator instead of the >= operator: