Which issues in your project actually have time logged? With Argon, one JQL function gives you the answer in seconds.
The problem
Time tracking is part of daily work in Jira. Teams log hours on bugs, stories and tasks. But when a manager or team lead asks a simple question, native JQL has no direct answer:
- Which issues in this project have work logged?
- Which issues has a specific person worked on?
Usually this means exporting data to Excel, opening issues one by one, or installing a separate reporting tool.
Argon: Powerful JQL for Jira adds a worklog() function to JQL. You write your normal query, put it inside the function, and Jira shows only the issues with logged work.
All issues with logged work in a project
Let's start with our test project MARS. A standard query returns every issue in the project:
project = MARS
Now put the same query inside the worklog() function:
issue in worklog("project = MARS")
The result is much shorter. Jira now shows only the issues where someone logged time. In our example, that is MARS-8 and MARS-2.
The rule is simple: whatever JQL you put inside the brackets, Argon returns only the issues from that result that have worklogs.
Issues where a specific person logged work
Often you need more than "has work logged". You want to know who logged it. The worklog() function takes a second, optional value: the user.
In project HERMES, the standard query returns all issues:
project = HERMES
Add the user's display name as the second value:
issue in worklog("project = HERMES", "Orbiscend")
Now you can see only the issues where the user Orbiscend logged time: HER-7 and HER-3.
Parameters for worklog function:
- subquery (required)
- author,
- start_date,
- end_date,
- min_time_spent ,
- max_time_spent.
When is this useful?
- Project managers: check which tasks have real effort behind them before a status meeting.
- Team leads: see what a team member worked on, without asking for a report.
- Billing and invoicing: list the issues with logged time for a client project.
- Sprint reviews: compare planned issues with the ones where work was actually logged.
You can put any JQL inside the brackets: a sprint, an epic, a status, a label or a date range. You can also save the query as a filter and use it on a dashboard.One function. No exports, no scripts. Argon runs on Atlassian Forge, so your data stays inside Atlassian.
Argon: Powerful JQL for Jira is available on the Atlassian Marketplace.
Try JQL Argon it and let us know which worklog questions you want to answer next.
Enjoy!
Orbiscend Team (JQL Argon app provider)
