Changelogs
The Changelogs additional export populates 2 tables in Snowflake:
Table Details
S4J_CHANGELOGS
This table contains information related to work item changelogs in Jira. All changelog information associated with the current export’s work items is stored in this table. One instance of this table is created per configured export location. All exports with the Changelogs additional export option selected will merge their work item’s changelog information into this table. For this reason, multiple exports per location may include this option without causing export processes to perform duplicate work. If all changelogs from Jira are required, then one or more exports containing all Jira work items must include this option.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
CHANGELOGID | INT | Changelog ID in Jira |
ISSUEKEY | VARCHAR | Changelog’s associated Jira work item key |
ISSUEID | INT | Changelog’s associated Jira work item ID |
AUTHORACCOUNTID | VARCHAR | Changelog’s associated Jira user account ID |
CREATED | DATETIME | Changelog creation timestamp from Jira |
S4J_CHANGELOG_ITEMS
This table contains information related to the items (fields) changed in individual Jira changelogs.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
CHANGELOGID | INT | Changelog ID in Jira |
FIELD | VARCHAR | Name of Jira field changed |
FIELDTYPE | VARCHAR | Type of Jira field changed |
FIELDID | VARCHAR | ID of Jira field changed |
FROMVALUE | VARCHAR | Original value in Jira field (raw) |
FROMSTRING | VARCHAR | Original value in Jira field (string) |
TOVALUE | VARCHAR | New value in Jira field (raw) |
TOSTRING | VARCHAR | New value in Jira field (string) |