Retrieving Work Logs via the API

Due to our privacy-first approach, detailed in this article, you must use the Jira REST API to retrieve work logs with JetTime metadata.

Scenario for Retrieving Work Logs

1. Retrieve Issues Using JQL

First, retrieve the issues you want to get work logs for using the Search for issues using JQL enhanced search endpoint. For example, search for specific project issues or issues with a particular custom field set.

Notes and Hints:

  • Use the worklogDate JQL field to limit issues to those with work logs in the selected date range.
  • Due to Jira’s inconsistencies in handling time zones, we recommend extending the date range by one day at the start and end of the range. Then filter individual work logs by their exact date.
  • Do not use the worklogAuthor JQL field, as JetTime stores work log authors in its metadata. For details, refer to Managing Work Logs for Others via the API.

2. Retrieve Work Logs for Each Issue

For each issue retrieved, use the Get issue worklogs Jira API endpoint. Make sure to include the expand=properties parameter to retrieve JetTime metadata for each work log.

Alternative Method

As an alternative, you can export all work logs through JetTime’s time report feature in the app UI. For details, refer to Exporting Work Logs to CSV Using the App Interface.

By following the above steps, you can efficiently retrieve work logs and include JetTime-specific metadata while aligning with our privacy-first design principles.