tasks time spent only in the sprint

[Ivan Andrieiev]

Is it possible to display in the filter only the tasks, only those in which the time spent is set only in the sprint I need?

[Walter Buggenhout · Accepted solution]

Hi @Ivan Andrieiev,

You can display tasks that are in a sprint and that have time spent against them. But it is not sure if the time spent will all be within your sprint.

The following JQL will display issues in sprint 12 (JQL replaces the sprint name with its ID) and that have time spent:

Sprint = 12 AND timespent > 0

But JQL always returns issues, not time spent. So if these hours were logged before your sprint started, the issues will still be returned by the filter.

Hope this helps!

[Ivan Andrieiev]

@Walter Buggenhout  Hi

That is, I cannot set the filter to only display the time in the corresponding sprint. The task is to determine the time for the sprint, not the one that was set earlier or later. For example, Jack spent 2 hours in Sprint 1, 5 hours in Sprint 2, and 10 hours in Sprint 3. All sprints are closed, I need to know how much Jack spent in Sprint 2?

[Walter Buggenhout]

Hi @Ivan Andrieiev, correct: you cannot do that with a filter; simple as that.

That is why there are plenty of reporting apps on the marketplace that allow you to do reporting on time spent rather than issues. Have a look at this list for inspiration! 

[Ivan Andrieiev]

@Walter Buggenhout  Hi

Thank you very much, I already use one application, but I have a basic filter, we will study this problem further.