I'm trying to figure out the query to get the issues in a sprint on a date
I tried sprint = 14 AND status was not EMPTY on "2015/07/03" ORDER BY key ASC
But it doesn't return issues that were in the sprint on that date.
Is there another field I can use that supports history? It doesn't work with the sprint field.
Screen Shot 2015-07-29 at 11.18.59 AM.png
Note we are trying to build a burn down chart with multiple status so we can see the stories that verified
Our work flow is to do => in progress => verified (on staging) => deployed (to prod)
Screen Shot 2015-07-29 at 11.44.32 AM.png
So our burn down tends to have the cliff at the end of the sprint.
As Nic mentioned this, unfortunately, can't be done.
Perhaps using Script runner or something similar it would be possible to get this information, but since none of this add-ons can be installed, or are available to JIRA Cloud, there's no way to get the results you want.
Hope this helps!
A new status, call it Never-Use, could be created.
The query becomes
sprint=14 and status was not Never-Use on "2015/07/03" ORDER BY key ASC
This should work.
Update: This query, like EMPTY, always returns 118 stories regardless of the date. Looks like 'NOT' does not behave as expected here. Looked good in theory.
sprint=14 and status was not Backlog on "2015/07/03"
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot