Re-opened jira not appearing in jql

Question

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_x6gjf3 · Answer

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.

Carlos Garcia Navarro · Answer

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!

Saju_iuwkuk · Answer

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