如何使用wiql获取特定团队的工作项目? [英] How to get work items for a specific team with wiql?

问题描述

我正在尝试使用dev ops rest api获取处于任何状态的特定PROJECT和TEAM的工作项. 正如中所确认的，积压工作项api不会执行，因为它不会返回完成"的项.

I'm trying to get work items in any state for a specific PROJECT and TEAM with dev ops rest api. As confirmed in my old question, the backlog work item api won't do, because it doesn't return 'done' items.

用wiql最好的方法是什么?

What's the best way to do that with wiql?

我特别遇到针对特定团队的过滤问题. Web界面导致使用@TeamAreas宏进行查询，但我不知道如何将其转换为wiql，因为Visual Studio 2017说不支持查询的语法".

I have issues in particular with filtering for a specific team. The web interface leads to a query with the @TeamAreas macro but I can't figure out how to translate it to wiql, as Visual Studio 2017 says that "the syntax of the query is not supported".

是否可以翻译@TeamAreas宏，还是可以快速检索特定团队的所有区域?

Is there a way to translate the @TeamAreas macro, or is there a quick way to retrieve all the areas for a specific team?

推荐答案

没有工作项目的团队字段.您需要从团队价值观中获取所有团队领域:

There is no team field for work items. You need to get all team areas from team values: Teamfieldvalues - Get. This is my example with c# Manage Team Settings.

然后您可以在wiql中使用此列表.

Then you may use this list in wiql.

这篇关于如何使用wiql获取特定团队的工作项目?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！