Re-opened jira not appearing in jql

[Saju]

I trying to run a query to get all the records that are in opened/unresolved state from last year, which means it excludes all issues that are closed the previous year. Here is the query I am using

project IN (x,y,z) and labels in ("a","b") and not status changed to (Closed, Resolved) before startOfYear()

with above I am almost getting all the result, but I see that few of the jira that were closed last year but got re-opened and resolved/closed this year does not appear. looking for some help

[Alexander Bondarev]

Hi @Saju !

Welcome to the Community!

If I correctly understand your case, try this query:

project IN (x,y,z) and labels in ("a","b") and createdDate >= startOfYear(-1) and createdDate <= endOfYear(-1) and resolution is EMPTY

 You will see all issues that were created in the last year and still have not been resolved.

[Saju]

Hi Carlos, it was re-opened and there was a second fix applied and closed this year. So eventually the status is closed. So basically the same jira ticket is closed twice, once last year and again this year. What it appears is, my current query picks up the first close. Not sure

[Carlos Garcia Navarro]

Hi @Saju ,

What is the status in your workflow when you reopen a ticket? Maybe 'Reopen' or 'Open'? If so you could include one of these clauses:

'OR status changed from Closed to Reopen'

'OR status changed from Closed to Open'

[Carlos Garcia Navarro]

I'm curious...If you run

'project IN (x,y,z) and labels in ("a","b") and status changed to (Closed, Resolved)'

,do you see these issues there?

Can you please attach a screenshot of your workflow, and double check if the status of the tickets that were reopened and closed have the status 'closed' or 'resolved'? Thanks!