Individual velocity and individual bugs fixed query

Question

I am trying to figure out how to isolate the tasks/issues completed in each sprint, per developer, to find out their individual velocity and how many bugs they are fixing overtime.

The problem is that when you search for issues with a status of done in a specific sprint, if that issue was in another sprint before, it will pull it twice in two different queries. How do you query ONLY the issues that were done in the sprint it was done in?

Same goes for bugs that were fixed (status = done) in each sprint.

Justin Ledoux · Answer

I have tried many permutation of what I know of JQL, and have not been able to find a way to do that... would you have an example to share?

Raimundas Juska · Answer

You should use jql - status changed to done during (sprint start date, sprint end date).