How to query on issues that had a specific status on a certain day

Mukesh Panchal

Hello,

Im trying to query issues having specific status as of a certain day e.g. I would like to know how many issues were fixed yesterday by checking issues transitioned from status A to status B, yesterday. I'm using following query:

 

issuetype = Bug AND status changed FROM "In Development" to "DEV COMPLETE" and (updatedDate < -1d AND updatedDate > -2d)

 

But this query shows me all the issues that were updated yesterday which once had a status of "In Development". I need to know issues that were changed from status of "In Development" to "DEV COMPLETE", yesterday. The issues may be in a different status now.

 

Any help is appreciated.

Daniel Deng

Try this one

(status changed FROM "In Development" TO "DEV COMPLETE" AFTER endOfDay(-2)) and (status changed FROM "In Development" TO "DEV COMPLETE" BEFORE  endOfDay(-1))