Query to find tickets from a period that status changed from status X to status Y

[Sandra De Pablo]

Hi all!

I have to review every 7 days how many tickets from two specific projects have been moved from one specific status to another status. I am not able to make it work. 

What I have tried but it doesn't work :( 

project = "XXXXXX" AND status changed to "TO DO" to "REVIEW" during ("2023/11/07", "2023/11/14")

Thanks in advance

[Alexis Robert]

Hi @Sandra De Pablo , 

I think your query is almost correct. You should just changed the first "TO" to "FROM" : 

project = "XXXXXX" AND status changed FROM "TO DO" to "REVIEW" during ("2023/11/07", "2023/11/14")

Let me know if this helps,

--Alexis