Versions
The Versions additional export populates 1 table in Snowflake:
Table Details
S4J_VERSIONS
This table contains information related to versions in Jira. All version information available from Jira is stored in this table. One instance of this table is created per configured export location. All exports with the Versions additional export option selected will merge version information into this table. For this reason, it is generally recommended that this option only be selected for one export per location. Otherwise export processes may perform duplicate work.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
VERSIONID | INT | Version ID in Jira |
DESCRIPTION | VARCHAR | Version description in Jira |
NAME | VARCHAR | Version name in Jira |
ARCHIVED | BOOLEAN | Flag indicating whether version was archived |
RELEASED | BOOLEAN | Flag indicating whether version was released |
STARTDATE | DATE | Version start date in Jira |
RELEASEDATE | DATE | Version release date in Jira |
OVERDUE | BOOLEAN | Flag indicating whether version is overdue |
USERSTARTDATE | VARCHAR | User start date in Jira |
USERRELEASEDATE | VARCHAR | User release date in Jira |
PROJECTID | INT | Version’s associated project ID in Jira |
ISSUESFIXEDCOUNT | INT | Number of issues fixed in version |
ISSUESAFFECTEDCOUNT | INT | Number of issues affected in version |
ISSUECOUNTWITHCUSTOMFIELDSSHOWINGVERSION | INT | Number of issues with custom fields showing version |
ISSUESCOUNT | INT | Number of issues in version |
ISSUESUNRESOLVEDCOUNT | INT | Number of unresolved issues in version |