获得工作项状态转换计数的最佳方法? [英] Best approach to get count of workitems state transitions?

问题描述

我需要为Azure DevOps创建一个仪表板小部件，以显示指定类型的工作项的数量，这些工作项从一种状态转换为另一种状态.

看起来Updates端点是我最好的选择，但这意味着我将必须遍历指定类型的所有工作项更新，然后确定其中是否包含我要查找的状态转换，例如封闭开放.

https://docs.microsoft.com/zh-cn/rest/api/azure/devops/wit/updates/list?view=azure-devops-server-rest-5.0

Analytics(分析)扩展看起来很有希望，但是看起来我需要查询Revisions数据集，并且其中不包含新旧值. https://docs.microsoft.com/zh-CN/azure/devops/report/extend-analytics/wit-analytics?view=azure-devops

用例是显示在过去90天内关闭并重新打开的错误的数量.我以为我可以使工作项的类型和往返状态可配置.

非常感谢任何想法或建议！

解决方案

您可以通过PowerBI来完成.计算入场时间现有Google Analytics(分析)视图的状态-

或者您所说的迭代工作项的所有更新.

I need to create a dashboard widget for Azure DevOps that shows number of work items of a specified type, that transitioned from one state to another.

It looks like the Updates endpoint is my best bet, but that means that I would have to iterate over all of the updates of workitems for the specified type and then determine if it contains the state transition I'm looking for, e.g. Closed to Open.

https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/updates/list?view=azure-devops-server-rest-5.0

The Analytics extension looked promising, but it looks like I would need to query the Revisions dataset, and that doesn't contain the old and new values. https://docs.microsoft.com/en-us/azure/devops/report/extend-analytics/wit-analytics?view=azure-devops

The use case is to show the number of bugs that were closed then reopened in the last 90 days. I thought that I would make the work item type and from and to states configurable.

Any ideas or suggestions much appreciated!

解决方案

You may do it through PowerBI. Calculate time-in-state for an existing Analytics view

Or as you said iterate over all of the updates of workitems.

这篇关于获得工作项状态转换计数的最佳方法?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！