Skip to content

Instantly share code, notes, and snippets.

@gladiatorAsh

gladiatorAsh/HierarichialQuery.md

Created September 17, 2020 04:59
Show Gist options
  • Save gladiatorAsh/956f550270a5e7307967fa221c651d00 to your computer and use it in GitHub Desktop.
Save gladiatorAsh/956f550270a5e7307967fa221c651d00 to your computer and use it in GitHub Desktop.
Download ZIP
Hierarchial Query in ADO
Raw
HierarichialQuery.md

SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State], [System.Tags] FROM workitemLinks WHERE ( [Source].[System.TeamProject] = @project AND [Source].[System.WorkItemType] <> '' AND [Source].[System.State] <> 'Done' AND [Source].[System.State] <> 'Closed'
) AND ( [System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward' ) AND ( [Target].[System.TeamProject] = @project AND [Target].[System.WorkItemType] <> '' ) MODE (Recursive)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment