How to list reopened issues?

[Kaur Kaur]

I am trying to list reopened issues for a specific time frames e.g. today, yesterday, this week with queriy as below

I just want to list the reopened issues 

project = lls AND updatedDate > startOfDay(-1d) AND type in (Defect, Enhancement) and status CHANGED FROM "Resolved" TO "In Progress"

also tried

project = lls AND  type in (Defect, Enhancement) AND (updatedDate > startOfDay() AND status changed to "In Progress" from "Resolved" and resolution changed to Unresolved)

[Mirek]

I see that you did not tried the WAS and DURING operators.. Example:

status was ("Reopened") DURING (startofweek(), endofweek())

Maybe this will help :smile: