JQL to track the efforts logged by the developers in the sprint

[Crp Rajan]

I would like to know how to track the efforts logged by the developers in the current sprint using JQL built -in functions and keywords?

[Trudy Claspill]

Hello @Crp Rajan 

Welcome to the Atlassian community.

What type of output are you trying to get?

JQL can provide you with a list of issues against which time has been logged during a time period with worklogdate field.

https://support.atlassian.com/jira-software-cloud/docs/jql-fields/#Worklog-date

If you combine that with a criteria for Sprint then you could get the issues in the sprint where work has been logged during a date range you specify:

sprint=X and worklogdate >= {insert start date of sprint} and worklogdate <= {insert end date of sprint}

Jira does not provide sophisticated time tracking reporting. If you want a report of the amount of time logged during a time period or by specific users that would require 3rd party apps.

[Rahul_RVS]

Hi @Crp Rajan  

Welcome to the community !!

For detailed time tracking reports if you would be interested to explore a mktplace app, pls take a look at

Worklogs Time Tracking in Jira & Timesheets

With this add-on, you can easily view all time entries for multiple issues day wise / month wise, user wise, grouped by in a single view. Also filter worklogs created between a date range as shown below. Main features of the app -

• Create time reports in real time by grouping & categorizing data with aggregation
• Prepare your reports based on Project/Sprint/Issue Type/Assignees and various other filters
• Group your data to build more meaningful reports
• CSV Export
• Dashboard gadget
• Enter Time Spent for multiple issues from Timesheet screen. With Calendar view and Board view

(Disclaimer: I am part of the app development team)

[Anastasiia Maliei SaaSJet]

Hi, @Crp Rajan

You’re right to look for a way to track developers’ logged efforts in the current sprint. It’s important to know, though, that Jira’s native JQL does not support querying or reporting directly on worklogs — Jira simply doesn’t provide built-in JQL keywords or functions for filtering or aggregating logged time.

That’s where the Time & Cost Tracker for Jira by SaaSJet comes in: it bridges this limitation by allowing you to combine your JQL filters with time and cost reporting, giving you a full view of developer efforts in your current sprint.

Here’s how:

✅ Use JQL with keywords like sprint in openSprints() to select all issues in your current sprint.
✅ Then, in Time & Cost Tracker, create a Cost Report based on this JQL filter.
✅ The app will automatically aggregate worklogs from those issues, showing time logged per developer, total hours, and calculated costs.
✅ You can also set hourly rates and planned budgets to compare actual vs. planned costs.

This gives you clear, detailed insights into your team’s real efforts in the sprint — something Jira alone cannot do.

Let me know if you’d like help setting it up! 🚀

[Anton from JetHeads_io]

Hi, @Crp Rajan! 👋

Native Jira does not support reporting on logged work time directly through JQL — you can’t query or aggregate worklogs natively by sprint or user.

However, you can build advanced time reports inside JetTime using JQL filters. For example, using:

sprint in openSprints()

you can generate a time report for all issues in the current sprint. You can also combine this with other filters, like project or assignee, to get exactly the data you need.

JetTime then aggregates the logged time on those issues, giving you clear insights into how much effort was spent in the current sprint by each developer or team.

JetTime is a privacy-first time tracking app built on Atlassian Forge, offering features such as:

• ✅ Timers and manual worklog entries

• ✅ Custom work log fields and metrics

• ✅ Powerful reporting with flexible filters and grouping

• ✅ Permission management and cost tracking

Let me know if you want help getting started!

👉 JetTime on the Atlassian Marketplace
— Anton, JetTime founder