I'm wanting to report on the date/time issues transition from "Status A" to "Status B". I'm not sure how to do this in JQL, or show the results in the issue navigator. Is there a better approach?
I can see this data in each individual issue's history, but I'd like to report on collections of issues without having to investigate each one.
Hi Barrett,
I don't think you can do it with JQL. The closest I've been able to get is using a WAS search to detect transitions during a certain time frame.
Ex: status was statusname DURING ("2017-01-01","2017-06-01")
Not quite what you want, I know.
But, if you have JIRA Server, you can get the transition info out of the database with SQL! I found it one day while looking to see which transition a user clicked to get from one status to the other.
The transition history is stored in a table called "OS_HISTORYSTEP." In that table, the status is stored in the column called "step_id", the transition is in "transition_id" (view your transition IDs in your workflow), the person who did the transition is in the "caller" column, and the transition start and finsh dates are there as well.
I hope something in here helps you!
Rachel Wright
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.