从JIRA数据库中提取冲刺开始和结束日期的最简单方法是什么？ [英] What is the easiest way to extract sprint start and end dates from the JIRA db?

问题描述

我正在尝试从Jira数据库提取冲刺的开始和结束日期。这似乎是一个简单的任务，但实际上（至少据我所知）并非如此。

I'm trying to extract the start and end days of my sprints from the Jira database. This would seem like a simple task, but it really (as far as I have found out at least) is not.

在试图弄清这一点时，我找到了一个解决方案，但在我看来如此繁琐又困难，我很难以为这是唯一的方法。

While trying to figure this out I found one solution, but it seems to me so cumbersome and difficult that I have problems thinking this is the only way.

这是我发现的内容：

Sprint不是本地的Jira表达式，Greenhopper插件使用

Sprints are not a native Jira expression and the Greenhopper plugin uses the projectversion table to represent sprints.

projectversion表包含有关sprint的一些信息，例如名称，它属于哪个项目以及发布日期。可以将发布日期视为冲刺结束日期，但是缺少开始日期。

The projectversion table contains some information about the sprint, like name, what project it belongs to and the release date. The release date can be thought of as a sprint end date, but the start date is missing.

如果您跑回冲刺，则可以将一个冲刺的开始日期设置为上一个冲刺的发布日期再加上一天？但这确实不是一个好的解决方案。

If you run back to back sprints maybe the start date of a sprint can be set to the release date of the previous sprint plus one day? But that is really not a good solution.

所以我搜索了Jira数据模型，并且我发现对冲刺开始日期的最佳且唯一的引用是在属性结构中。

So I searched through the Jira data model and the best and only reference I found to a sprint start date was in the property structure.

您可以定义属性并为其分配值。在此结构的主表（属性条目表）中，我找到了以下条目：

You can define properties and assign them values. In the main table of this structure, the propertyentry table, I found entries like this:

ID     ENTITY_NAME     ENTITY_ID     PROPERTY_KEY                          propertytype    
-----  --------------  ------------  ------------------------------------  ------------
 10288  GreenHopper     10010         CONFIGURATION                         6               
 10304  GreenHopper     10012         CONFIGURATION                         6               
 10312  GreenHopper     10013         CONFIGURATION                         6               
 10449  GreenHopper     10014         CONFIGURATION                         6   

所以GreenHopper添加了一个键设置为CONFIGURATION的属性。 etity_id字段引用project.id，配置属性是项目配置。 property_type设置为6，这告诉我们要在propertytext表中查找值。

So GreenHopper have added a property with the key set to CONFIGURATION. The etity_id field references project.id and the configuration property is a project configuration. The property_type is set to 6 which tells us to look for the value in the propertytext table.

propertytext表中存储的值将其本身显示为包含不同字符串的XML字符串有关该项目的信息，例如：

The value stored in the propertytext table reveals it self as a XML string containing different information about the project, among it entries like this:

<entry>
  <string>BURNDOWN_START_DATE_10074</string>
  <long>1316988000000</long>
</entry> 

有。我找到的最佳等效冲刺开始日期。隐藏在属性表的xml字符串中。

There it is. The best equivalent I have found to a sprint start date. Hidden in an xml string in a property table.

我的问题是：这真的是找到我的冲刺开始日期的唯一方法吗？

My question is: Is this really the only way to find my sprint starting dates?

推荐答案

如果可以避免，我不建议直接访问JIRA数据库。未记录的JIRA Agile REST API，例如rest / greenhopper / 1.0 / rapid / charts / sprintreport.json？rapidViewId = 652& sprintId = 577，其中RapidViewId是木板ID，
提供您Sprint信息。可以在jira-python库中的 http：// jira-python .readthedocs.org / en / latest /

I don't recommend accessing the JIRA database directly if it can be avoided. The undocumented JIRA Agile REST API such as rest/greenhopper/1.0/rapid/charts/sprintreport.json?rapidViewId=652&sprintId=577 where rapidViewId is the board id, gives you the Sprint information. This and other REST resources can be seen in the jira-python library at http://jira-python.readthedocs.org/en/latest/

这篇关于从JIRA数据库中提取冲刺开始和结束日期的最简单方法是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！