Using the JQL function workedIssues(), you can include Time Tracker data in the JIRA advanced search. This function returns all issues with worklogs within a given date range, filtered by a specific user or group.
This function is not built into the Time Tracker UI. It is available as a JQL function that can be used anywhere Jira accepts JQL queries, such as:
-
Jira’s Advanced Search (Issue Navigator)
-
Board/Backlog filters
-
Saved filters and dashboards
-
Any other Jira feature that supports custom JQL
You must have auditor permissions to retrieve data for other users or groups. Otherwise, you can only query your own worklogs.
Syntax
issue in workedIssues(fromDate, toDate, byUserOrGroup)
Parameters
fromDate / toDate
The date range to filter worklogs. Accepted formats include:
-
yyyy/MM/dd
-
yyyy-MM-dd
-
yyyy/MM/dd HH:mm
-
relative values such as -5d, 1w 2d
byUserOrGroup
A Jira username or group name whose worklogs should be considered.
Usage Examples
-
Issues worked on by a specific user in January 2024:
issue in workedIssues("2024/01/01", "2024/01/31", "john.doe") -
Issues worked on by members of a group:
issue in workedIssues("2024/01/01", "2024/01/31", "jira-developers") -
Combined with other JQL filters:
project = "MY-PROJECT" AND issue in workedIssues("2024/01/01", "2024/01/31", "john.doe")