JQL for tickets closed in a specific sprint

[Samantha Sharkov]

Hi,

My current query currently pulls out the tickets that were closed in the sprint before the last one and were moved to the next sprint. (Not sure why this is happening).

The tickets in question are DONE and haves two sprints (A, B). I need a query that will only show the tickets that were resolved in sprint B. Please advise. Current query:

issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint = 988.

In results, I see tickets that are Done but both sprints A and B...

[Pramodh M · Accepted solution]

Hi @Samantha Sharkov 

Could you please try below query and let me know the result

issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint in openSprints()

OR

issuetype in (Bug, Story, Task) AND project in (CORE) AND status in (Done) AND Sprint = B AND sprint not in closedSprints()

Thanks,
Pramodh

[Samantha Sharkov]

Thank you very much, I will try. When I run this query I usually have both sprints closed..

[Samantha Sharkov]

My issue was solved here https://community.atlassian.com/t5/Jira-questions/JQL-for-closed-date-vs-created-date/qaq-p/595575 with status changed to Done after "2022-03-17"