name of database element for start date on iteration/release

I need to use the dates that we can enter for the burn down chart for some custom reporting; but my developer can't find the field for the "start" date in the sql database. We have the release date from version table or project table, I forget which. But he cannot find the start date. Can anybody point me in the correct direction?

Yaks Beth, I think you will have a hard time doing it via a SQL query.
The settings of GReenHopper are saved as an XML "string" into the data base.

This xml contains a bunch of things and it would be kinda hard to parse that string to find what you need.

You might want to do it via some code - the dates are easily accessible via the GH API.

Let me know if you wish to have the code to extract it.

Cheers,

Definitely want it - thanks!

Sure here it is:

Code:

 Date startDate = new ProjectConfiguration(myProject).getVersionStartDate(myVersion);

Where of course
myProject = the org.ofbiz.core.entity.GenericValue of your project
myVersion = the com.atlassian.jira.project.version.Version of your version

ProjectConfiguration is com.pyxis.greenhopper.jira.configurations.ProjectConfiguration

Hope this helps.

Cheers,

It is posible to get tha table name where the date is stored!

Hi,

We are facing a similar problem. We use a custom script that connects with the Jira database to report on the sprint hours. However, in order for the report to be in sync with the GH, there needs to be a way to capture the version start date. I understand that it was earlier mentioned in the thread that the start date of GH is saved as an XML string in the database and is hard to mine via SQL but knowing which table to search would still be beneficial.

Using GH API is not the option for us. Please let us know if grabbing the XML string can be done via SQL even if it is only a remote possibility.

Thank you,
Saach

Sure saach,

You can retrieve the XML of the project configuration in the PropertyText table.
This one is linked with the PropertyEntry Table.

Here is a sample xml you could use:
Code:

 SELECT *
 FROM `propertytext`
 WHERE ID = (
 SELECT ID
 FROM `propertyentry`
 WHERE ENTITY_NAME = 'GREENHOPPER'
 AND ENTITY_ID = YOUR_PROJECT_ID
 AND PROPERTY_KEY = 'CONFIGURATION' )

This will give you the xml.
Now the associations are kept in the nodes VERSION_MATCHUP

Code:

 [entry]
    [string]VERSION_MATCHUP[/string]
    [map]
      [entry]
        [long]11410[/long]  [!-- MASTER VERSION ID --]
        [long]11322[/long]  [!-- CHILD    VERSION ID --]
      [/entry]
      [/map]
 [/entry]

I hope this helps.
In a very near future this should be kept in a proper dedicated table directly in JIRA since now GreenHopper is fully part of Atlassian.

Cheers,
JC

Hi there,

I was wanting to do exactly the same thing. Has the start date been migrated to a proper table in Jira?

Regards,
-Richard.