admin管理员组

文章数量:1405329

I'm setting up ADO for my team and trying to write some queries, and I'd like to write one to show me anything that is in a New or Active state but where all the children are closed.

I have set the setting to close parents if the children go active, but I'm just trying to clean up the backlog they currently have and figured this would be a query for a good sanity check every once in a while.

I've tried fooling around with the query editor a bunch. Currently trying

Query type: Work items and direct links

Top:

  • Work Item Type = [Any]
  • And State in New, Active

Filter:

  • Work Item Type = [Any]
  • And State in New, Active

Filter option:

  • Only items that do not have matching links
  • Return selected link types - Child

I'm setting up ADO for my team and trying to write some queries, and I'd like to write one to show me anything that is in a New or Active state but where all the children are closed.

I have set the setting to close parents if the children go active, but I'm just trying to clean up the backlog they currently have and figured this would be a query for a good sanity check every once in a while.

I've tried fooling around with the query editor a bunch. Currently trying

Query type: Work items and direct links

Top:

  • Work Item Type = [Any]
  • And State in New, Active

Filter:

  • Work Item Type = [Any]
  • And State in New, Active

Filter option:

  • Only items that do not have matching links
  • Return selected link types - Child
  • azure-devops
Share Improve this question asked Mar 8 at 13:57 BeepBoopZombieBeepBoopZombie 11 bronze badge
Add a comment  | 

1 Answer 1

Reset to default 0

Azure DevOps can not query and compare/analyze received data. As a workaround, you may query:

Top:

Work Item Type = [Any]
And State in New, Active

Filter:

Work Item Type = [Any]
And State <> Closed

Filter option:

Only items that do not have matching links
Return selected link types - Child

In this case, you'll receive work items without child links or with all closed child work items. Additionally, you may add to the Top Related Link Count > 0 to exclude work items without links.

本文标签： Azure DevOps QueryActiveNew Parent where all children are ClosedStack Overflow

版权声明：本文标题：Azure DevOps Query - ActiveNew Parent where all children are Closed - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744894455a2630975.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。