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

Question

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_z1zl10 · Accepted Answer

Hi @Aileen Leitner Buck .

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.