JQL query to find actual time spent on particular issue in a project. I need query to run it.

Question

I want to get a report of a tester (user) how much time is being spent on the particular ticket or particular set of the ticket from one status to another. I have status called "Ready for qa > QA started > resolved in trunk.

So, i want to know how much time is spent from "Qa started to resolved in trunk".

Can someone help me write query in timespent?

Alexey Matveev · Answer

It will show you tickets, which are not currently in status Resolved In Trunk, because you could change the status later. If you want to find issues, which are still in the Resolved In Trunk status then you should write a JQL query like this:

project = "Online Application v4" AND status changed TO "Resolved In Trunk" by suyambu and status = "Resolved In Trunk"

Balasubramanyan murugan · Answer

NO :(

Tried your suggestion it's not pulling result as expected. It brings all another status as well.

project = "Online Application v4" AND status changed TO "Resolved In Trunk" by suyambu

Alexey Matveev · Answer

Try to do it like this:

status changed from New to Assigned DURING (startOfDay(-3), now())  by user