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:
Identify project ID using query below:
Identify all your project version ID using query below (e.g. project ID = 10000) :
- From the result, you will find all version ID and Release date of these version if they have any.
Then Run query below to retrieve JIRA Agile data for the project:
From the result, look for VERSION_MATCHUP like example below:
- From example above, version 10300 is the parent version of version 10301.