Want to see only issues that are not done in the current (active) Sprint

Tom Judge_917oq5

Want to view only issues that are not done but are in the current (active) Sprint. Want to do this so we can see what issues are NOT DONE yet in the current sprint and may or may not be candidates for the next sprint as part of backlog refinement. I know we can do a sprint report that shows incomplete work. But is there another way?

Tried this: 

project = CSDSOSRE AND issuetype = Story AND NOT (status = Done AND Sprint not in openSprints()) ORDER BY "DevSecOps Practice Area"

Mark Segall

Hi @Tom Judge and welcome to the community!

It looks like your query needs a slight adjustment.  The query is saying "NOT IN openSprints()".  By definition it sounds like you actually want issues in active sprints so this would do the opposite.  Try this:

project = CSDSOSRE AND issuetype = Story AND sprint in openSprints() AND status != Done ORDER BY "DevSecOps Practice Area"