JQL to find issues which are specific time in status

Question

Hey, I need to find all issues which are in Status "A" for exactly 21 days from now.

So if the issue is in status "A" for 20 or 22 Days, the JQL should exclude these issues.

It probably is some JQL with "Not status changed after/during/to..."

Can someone tell me the correct JQL?

Thanks in advance!

Sidney Mätzke · Answer

Hi @Jerrold - Empyra

thanks, the last suggestion was good, but we had to add a part at the end to exclude issues that changed to another status during these 21d and then back again to the original status.

So this is the JQL that worked for us.

(status = Closed AND status changed TO "closed" ON -21d AND status changed BEFORE -20d) AND not status changed AFTER -21d

Jerrold - Empyra · Answer

Hi @Sidney Mätzke

I am really sorry that it didn't work I am not able to test the JQL in my test instance as i don't have issues in a status for  21 days I hope this JQL works

status = "In Progress" AND status CHANGED TO "In Progress" ON -21d AND status CHANGED AFTER startOfDay(-1)

or

status = Closed AND status changed TO "closed" ON -21d AND status changed BEFORE -20d

Thank you

Sidney Mätzke · Answer

Hi @Jerrold - Empyra

thank you, but sadly it's the same result. It still shows issues which has been for 21 days in this status at some time. Do you have another suggestion?