Time dedicated to a task during a period of dates in JQL

[Alba Gómez Manteiga]

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.

[Valeriia_Havrylenko_SaaSJet]

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

[Nic Brough -Adaptavist-]

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)

[Trudy Claspill]

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.

[RVS_Support]

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.

• Worklogs Report :
  • Create reports for time entered by your team members
  • Filter/Categorize/Group By your worklogs data
• Timesheets : View/Enter time spent for multiple issues and multiple days from a single screen
• Dashboard gadgets

Disclaimer : I am part of the app development team