By making a query in JQL, how can I get the hours dedicated to an incident, but only the hours spent during the current sprint? That is, I don't want to see the total time spent on the task but the time spent in a period of time.
Welcome to the Atlassian Community!
JQL is for finding issues, it does not have any reporting.
All you can do here is read the issue worklogs on the issues to see who logged how much time and when (and note that the worklog date/time is the time the worklog was created, it's not necessarily the date that the work was done)
Adding to Nic's answer...
Jira doesn't provide much natively for reporting on time spent on issues, except for reporting on the total time.
If you want more granularity you will need a third party app.
There are several available from the Atlassian Marketplace.
Hi @Alba Gómez Manteiga
Welcome to the community !!!
As others suggested, a mktplace app can help you to get this data.
You can try out our add-on
Worklogs Time Reports
The app provides the following features.
Disclaimer : I am part of the app development team
Hi @Alba Gómez Manteiga 👋
Welcome to the Atlassian Community!Unfortunately, with JQL doesn't have reporting functionality. But you can use a marketplace add-ons to get reports. As an alternative , I guess you can try Time in Status for Jira Cloud (developed by my SaaSJet team) with 7 types of status time reports. In our add-on we have functionality to get time spent in a period of time. Here is a use case for this → How to calculate data with Issues and Time Reporting (trim) Periods?
Add-on has a 30-day free trial version and free up to 10 users. Please, let me know if you have any questions
Hope it helps 😌Valeriia
It looks like you're new here. Sign in or register to get started.