JQL giving the lastSprint where the issue has been resolved

[agnes BOURLON]

Hi

I have some tickets with 2 , 3 or more sprints due to the fact that they were not being closed in the first sprint and the team delayed resvoling over some sprints 

Is there a way to get the last sprint , the sprint when the issue was really closed?

Best regards 

Agnes

[Frederik Vantroys · Accepted solution]

To find the last sprint in which a ticket was closed you can use the CHANGED operator along with the status field. Here's an example JQL query:

status changed TO closed DURING ("start of sprint"-"end of sprint")

[agnes BOURLON]

Nice Frederik ! Just to clarify for all, if the sprint started at "2023/03/28 12:00" and finished a month later, the request would be : 

status changed TO closed DURING ("2023/03/28 12:00", "2023/04/28 12:00")