How do I write a JQL query for issues that roll over from prior sprints?

[Aileen Leitner]

I am trying to pull a report for all issues assigned to open sprints. However, I've noticed that when using "sprint in openSprints()" condition it excludes any issues that have rolled over from prior sprints. Even updating the Sprint to the active sprint name excludes these issues. How can I report on these issues?

[KAGITHALA BABU ANVESH · Accepted solution]

Hi @Aileen Leitner .

JQL : Sprint in openSprints() and Sprint in closedSprints()

The above JQL shows issues in current sprint and previous sprint. that means sprint field will have two or more sprint values.