Knowledge Base Articles
Knowledge Base Articles
Breadcrumbs

How to export worklogs of archived issues

Question

We have a use case where we want to archive issues from last year. When we archive a ticket, it still appears in filled-out and locked Tempo timesheets.

But this worklog does not export to SQL using the connector.

Is there any way for us to also export archived issue worklogs into SQL?

Answer

Currently, two different tables allow exporting worklogs - "Issue Worklogs" and "Tempo Worklogs":

  • "Jira Work Management" > "Issue Worklogs". It does not fetch worklogs of archived issues due to constraints in the Jira API. In particular, this API does not return archived issues in a bulk request (but could return them in a direct request, which is of no help with the current app logic).

  • "Tempo" > "Tempo Worklogs" (includes only worklogs generated with the Tempo app). It should contain worklogs associated with the archived items since they are present in the Tempo API.