Help: How do I write a filter for tracking work across sprints?

[Mister Femi]

Hello all, how do I create a filter to show backlog items carried over from sprint to sprint? 

[Ste Wright · Accepted solution]

Hi @Mister Femi 

Does this work for you?

sprint in closedSprints() AND (Sprint in openSprints() OR Sprint in futureSprints())

^ This provides all Issues:

• Which are in a Closed Sprint and...
• Are in an Open Sprint (i.e an active Sprint) or...
• A future Sprint (i.e a planned Sprint)

Ste

[Mister Femi]

Thanks @Ste Wright This helpful but will those show user stories carried over into the next sprint? 

[Ste Wright]

Hi @Mister Femi 

Yes, this query is showing Issues which are in 2+ Sprints, where one is closed, and the other is active/planned.

You could customise it based on whatever other logic you need - for example if it's for Stories which are not closed/done, it might be:

issuetype = Story AND resolution is EMPTY AND sprint in closedSprints() AND (Sprint in openSprints() OR Sprint in futureSprints())

Ste

[Mister Femi]

Spot on @Ste Wright Exactly what I am looking for. Thank you so much. Final question, if we are looking for uncompleted stories, shouldn't it read AND RESOLUTION is EMPTY? Pls clarify. Thanks

[Ste Wright]

Hi @Mister Femi 

Yes it should - sorry about that!

I've updated my response above, thank you for letting me know it was incorrect.

Ste

[Mister Femi]

Thanks for your help.