尝试将TFS查询转换为WIQL查询 [英] Trying to convert TFS query to WIQL query

问题描述

您好，

我正在尝试将TFS查询转换为WIQL查询。 

以下是我的内容到目前为止，但这是错误的。它只返回工作项的子链接，但我想要工作项的父链接。如何获得ID = 4839的工作项的所有父链接。这包括祖父母，曾祖父母...

SELECT [System.Id]，[System.WorkItemType]，[System。标题]，[System.AssignedTo]，[System.State]

FROM WorkItemLinks

WHERE目标。[System.TeamProject] ='MyProject'

AND Source。[System.Id] = 4839

AND [System.Links.LinkType] ='System.LinkTypes.Hierarchy-Forward'à
mode（Recursive）

解决方案

嗨！

试试这个例子：

 SELECT [System.Id]，[System.WorkItemType]，[System.Title]，[System.AssignedTo]， [System.State]，[System.Tags] 
 FROM WorkItemLinks 
 WHERE（[Source]。[System.TeamProject] ='MyProject'）And（[System.Links.LinkType] ='System。 LinkTypes.Hierarchy-Forward'）和（[Target]。[System.Id] = 4839）
 ORDER BY [System.Id]模式（Recursive，ReturnMatchingChildren）

Hello,

I'm trying to convert a TFS query to a WIQL query. 

Below is what I have so far but it is wrong. It only returns the child links of a work item, but I want the parent links of the work item. How can I get all parent links of the work item with Id = 4839. This includes grandparents, great-grandparents...

SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State]
FROM WorkItemLinks
WHERE Target.[System.TeamProject] = 'MyProject'
AND Source.[System.Id] = 4839
AND [System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward'
mode(Recursive)

解决方案

Hi!

Try this example:

SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State], [System.Tags] 
FROM WorkItemLinks 
WHERE ([Source].[System.TeamProject] = 'MyProject') And ([System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward') And ([Target].[System.Id] = 4839) 
ORDER BY [System.Id] mode(Recursive,ReturnMatchingChildren)

这篇关于尝试将TFS查询转换为WIQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！