You could use JQL to pull that information. Just put the statuses in that you are interested in and the date range of the sprint and who changed them.
project = "Project Name" AND status changed FROM "Status A" TO "Status B" DURING ('yyyy/MM/dd', 'yyyy/MM/dd') BY "username"
Or for multiple statuses
project = "Project Name" AND status changed FROM "Status A" TO ("Status B", "Status C") DURING ('yyyy/MM/dd', 'yyyy/MM/dd') BY "username"
Thanks Brant, I misstated the use case. I just want to show the issues that have the statuses of done and code review for a particular assignee for a given sprint.
I don't want to show the length of time that it took the issue to move from one status to another, although that will help in other reports.
Thank you for the quick response.
Sorry if I was not clear. The reason I suggested using dates is you can align those dates with when the sprint ran. Is you use sprint = "SprintName" it could pull in transitions outside of the sprint run date. The dates do not have anything to do with the length of time the issue took to move but when the transition could have occurred.
Hi Brant, thank you. Here's my JQL statement:
project = "projectX" AND status = ("Done") DURING ('2020/10/26', '2020/11/06')
but I'm getting this error:
Error in JQL Query: The EQUALS operator does not support the use of the during ("2020/10/26", "2020/11/06") predicate.
I'm just looking for issues with the status of Done for that time period in projectX.
During is looking for some sort of change during a time period. Since the status you have is a specific static value. it will give an error. You could use the following JQL but it might not get you exactly what you need:
project = projectX AND status = Done AND updated >= 2020-10-26 AND updated <= 2020-11-06
I would suggest do the following:
project = projectX AND status changed FROM ("Any Statuses that can transition to Done", "Status C") TO (Done) DURING ('2020/10/26', '2020/11/06')
If you can go from every status to development try this and see what it gets you.
project = "projectX" AND status changed from ("Queue", "Code Review", "Merged to Dev Branch", "QA", "Ready for Release", "Done") TO (DEVELOPMENT) DURING ('2020/10/26', '2020/11/06')
Please make sure that the status are correct as they are case sensitive.
Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events