Locate Version Hierarchy in JIRA Database

Still need help?

The Atlassian Community is here for you.

Ask the community

By default, JIRA doesn't support nested version while JIRA Agile support it.

As such, JIRA Agile store the version relation information in XML format in propertytext table. To find them:

 

  1.  Identify project ID using query below:

    select * from project;
    
  2. Identify all your project version ID using query below (e.g. project ID = 10000) :

    select * from projectversion where project=10000;
    
  3. From the result, you will find all version ID and Release date of these version if they have any.
  4. Then Run query below to retrieve JIRA Agile data for the project:

    select propertyvalue from propertyentry e join  propertytext t on e.id=t.id where entity_id =10000;
    
  5. From the result, look for VERSION_MATCHUP like example below:

    <map>
      <entry>
        <string>VERSION_MATCHUP</string>
        <map>
          <entry>
            <long>10301</long>
            <long>10300</long>
          </entry>
          <entry>
            <long>10100</long>
            <long>10000</long>
          </entry>
        </map>
      </entry>
    ... 
  6. From example above, version 10300 is the parent version of version 10301.

 

Last modified on Aug 26, 2013

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.