jql query for issues in sprint

Question

Hi

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.

Thanks,

Tom

Screen Shot 2015-07-29 at 11.18.59 AM.png

Screen Shot 2015-07-29 at 11.44.32 AM.png

Peter Jones · Answer

A new status, call it Never-Use, could be created.

https://confluence.atlassian.com/display/JIRA/Defining+Status+Field+Values?continue=https%3A%2F%2Fconfluence.atlassian.com%2Fdisplay%2FJIRA%2FDefining%2BStatus%2BField%2BValues&application=cac

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"

Peter

Tom McKenzie · Answer

I guess we could run a query every day to grab a "snapshot" and total the points?

Tom McKenzie · Answer

Maybe I could try pulling the history for each issue to see when it got added and removed from a sprint?  That seems kind of "heavy handed" but I guess that would work?