Using JQL, can I filter out stories started but not completed in a Sprint?

Question

Hi,

I'm trying to build a query (for a dashboard gadget) that lists stories completed in a particular Sprint (including going back over past, closed Sprints), so I can show delivered points by Sprint.

As such, I want to explicitly omit stories starting in particular Sprint, but which are then carried over to the next Sprint.

For example, take Story X. This story is started in Sprint 1, but then carried over into Sprint 2, when it is eventually flagged as Done.

If I search for 'Done' stories in Sprint 1, I want to omit Story X from this list as during Sprint 1, it was not 'Done'.

Is this possible?

cheers

Paul

Paul Relf-Davies · Answer

Thanks Carlos,

Unfortunately I don't think that would work.... I need this to work the same for current/open Sprints and past/close Sprints.

The thing is that I need to identify stories that between 'Done' in a particular (open or closed or current or past) Sprint.

TBH, I don't think this is possible (out of the box at least) as Jira JQL doesn't seem to give access to query a story's history - just its current state - AFAIK!!

That said, I thought it worthwhile to ask the wider community :)

cheers

Paul

Carlos Garcia Navarro · Answer

Hi Paul,

You can use clauses such as:

sprint is not EMPTY and sprint not in closedSprints() and sprint in openSprints()

to indicate that a story wasn't in a sprint that now is closed and also that is in the current active sprint.

Hope it helps,

Carlos