How to export issues with resolution "Done" and "Closed" from last year

Question

Hello There,

I'm triyng to export issues from last year with the resolution "Done" and "Closed" but my JQL is returning issues from this year to.

project in (XPTO,XPTI) AND issuetype in (Bug, RAD) AND status in (Closed, Done) AND resolutiondate >= 2023-01-01 AND resolutiondate <= 2023-12-31 ORDER BY updated DESC, created ASC, summary ASC

Could you help me?

Thanks

Laurie Sciutti · Answer

Hi @Soraia Luís ~ you can also try:

resolved >= startOfYear(-1) AND resolved < startOfYear()

unknown · Answer

Trying using resolved instead of resolutiondate.

Also, unless you have other statuses other than Done or Closed for resolved issues, then adding the "status in (Done, Closed)" to the JQL is duplication, since finding issues with resolved dates is the same thing.