Worklogs
The Worklogs additional export populates 1 table in Snowflake:
Table Details
S4J_WORKLOGS
This table contains information related to work item worklogs in Jira. All worklog 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 Worklogs additional export option selected will merge their work item’s worklog 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 worklogs 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 |
WORKLOGID | INT | Worklog ID in Jira |
ISSUEKEY | VARCHAR | Associated Jira work item key |
PROJECTKEY | VARCHAR | Associated Jira project key |
AUTHOR | VARCHAR | Worklog author Jira user account ID1 |
STARTDATE | DATETIME | Worklog start date timestamp |
TIMESPENT | INT | Worklog time logged (minutes) |
UPDATEAUTHOR | VARCHAR | Worklog update author Jira user account ID1 |
UPDATEDATE | DATETIME | Worklog update date timestamp |
COMMENT | VARCHAR | Worklog comment |
1For Jira instances using Tempo Timesheets, this information points to the Tempo Timesheets user, not the actual Jira user who created or updated the worklog. To retrieve the actual Jira user information, select the Tempo Timesheets export option and review the S4J_TEMPOWORKLOGS table in Snowflake.