in Advanced Search, is there a way for the Sprint field to not show closed sprints?

[michaelreiff]

I know how to construct a JQL query to find tickets assigned to open or future sprints, but the results displayed in search in the sprint field still show ALL sprints the tickets is or was assigned to.  Is there a way so that only the open or future sprints are shown?

[Trudy Claspill]

Hello @michaelreiff 

No, that is not an available option. The Sprint field will show all sprints to which the issue has been assigned.

You might be able to come up with a work-around to maintain the Active/Future sprint for an issue in a separate field. You would need to use Automation Rule(s) to keep that field current.

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

JQL does not report on issues, it just finds them and reports a list back.

All the reporting that uses JQL on the back-end that I'm aware of simply report what the content of a field is.  The issue navigator, gadgets, reports, etc, they just tell you what the content of a selected field is.

So, no.  JQL can't do this, it doesn't display anything.  There are no gadgets or reports that misrepresent field content either.