How to remove closed sprint from current sprint issue?

[leonardo_zaboto]

I would like to remove the closed sprint attached to the sprint field. It is breaking my query when I try to search Sprint is EMPTY. Since the old sprint is there, the EMPTY function is not working as expected.

[Trudy P Claspill]

Hello @leonardo_zaboto 

Welcome to the Atlassian community.

Actually the EMPTY function is working exactly as designed. The Sprint field is not empty; it contains the history of the sprints to which the issue was assigned and never removed. This is working as designed.

If you remove the closed sprint information from the field that will change the sprint reports for those sprints to show the issue as Removed from the sprint. That could impact other sprint metrics.

What are you actually trying to retrieve with your query? If you want to exclude issues that were in sprints that have been closed then you can use

(sprint is empty or sprint not in closedSprints()