如何使用第一版 api 获取项目和冲刺燃尽图? [英] How do I use the version one api to get project and sprint burndown charts?

问题描述

我正在尝试使用 第一版 api 来获取项目和冲刺燃尽图.

I am trying to use the Version One api to get the project and sprint burndown charts.

我正在阅读此页面，但我刚刚迷茫.

I am reading this page but I am just getting confused.

有没有人做过类似的事情，并有任何关于如何点击 api 以获得我想要的东西的提示?

Has anybody done something similar and have any tips for how to hit the api to get what I want?

推荐答案

VersionOne api 不提供图像或图表特定数据.您可以使用查询语言和其余端点来生成燃尽所需的数据.您需要能够读取/解析数据并自己生成图表.

The VersionOne api does not serve images or chart specific data. You can use the query language and the rest endpoint to produce the data that is needed for a burndown. You would need to be able to read/parse the data and produce a graph yourself.

话虽如此，燃尽图比较了多少封闭估计与多少开放估计以及随时间变化的图表.所以你需要知道三个数据:开放估计、封闭估计和时间.您还需要将其限制为某个项目(以及它的孩子).

With that being said, a burndown graph compares how much closed estimate versus how much open estimate and graphs that over time. So you need to know three pieces of data: open estimate, closed estimate, and time. You'll also want to limit it to a certain project (and it'd children).

这应该会让您接近项目燃尽所需的数据:

This should get you close to the data you need for a project burndown:

http://<host>/VersionOne/rest-1.v1/Data/Timebox?where=Schedule.ScheduledScopes='Scope:1055'&sel=Name,BeginDate,EndDate,Workitems:Story[AssetState!='Closed'].Estimate.@Sum,Workitems:Story[AssetState='Closed'].Estimate.@Sum&sort=+EndDate

务必将 Scope:1055 更改为您感兴趣的项目 oid.

Be sure to change Scope:1055 to the project oid that you're interested in.

这就是我到达那里的方式.首先我在想好吧，你需要总结一堆故事估计"，所以我想我会对故事进行历史查询:

This is how I got there. First I was thinking "well you need to sum up a bunch of story estimates" so I thought I'd do a historical query of stories:

http://<host>/VersionOne.Web/rest-1.v1/Hist/Story?where=Scope.ParentMeAndUp='Scope:1055'

但很快发现您无法在根上聚合.这意味着如果我想总结估计，我需要使用其他类似项目(范围)的东西来获取数据:

But quickly found that you cannot aggregate on your root. What that means is if I want to sum up estimate, I need to use something else like Project (scope) to get at the data:

http://<host>/VersionOne.Web/rest-1.v1/Hist/Scope/1055?sel=Workitems:Story[AssetState!='Closed'].Estimate.@Sum,Workitems:Story[AssetState='Closed'].Estimate.@Sum,ChangeDate

这个查询的问题是在奇怪的时间间隔内给出了封闭估计和开放估计的样子；即每当项目发生变化时.所以它不会制作出非常漂亮的图表.

The problem with this query is is gives you what the closed versus open estimate looked like at weird intervals; namely whenever the project changed. So it wouldn't make a very nice looking graph.

但如您所知，VersionOne 有一个与项目相关联的迭代和计划的概念，而故事与迭代相关联.所以我用它作为根来查询和聚合故事估计，并将数据限制为使用该时间表的项目.

But as you know VersionOne has a concept of Iterations and Schedules that are associated to a project, and stories are associated to iterations. So I used that as a root to query for and aggregate story estimates, and limit the data to projects that use that schedule.

生成的数据更规则(按迭代分组)并且包含正确聚合的估计数据.

The data that is produced is more regular (grouped by iteration) and contains correctly aggregated estimate data.

还剩下什么?您必须聚合估算数据的聚合才能获得项目的总估算数.然后您需要生成一个图形(可能是条形图或线形图)，其中每个数据点都位于迭代的末尾.您将保留封闭估计的运行总计，并将其添加到迭代的总计中以生成数据点.

So what is left? You'll have to aggregate the aggregation of estimate data to get a total estimate number for your project. Then you'll need to produce a graph (maybe bar or line) where each data point is at the end of an iteration. You'll keep a running total of closed estimate and add that to the iteration's total to produce the data point.

这篇关于如何使用第一版 api 获取项目和冲刺燃尽图?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！