JQL for tickets did not change status for 24 hours

Question

Need JQL to get Jira tickets which did not move to a specific status within 24h after creation time

Need to all tickets which did not change status to "ready for review" within 24 hours.

Sanjen Bariki_rtm841 · Accepted Answer

Hi @Heba Rezk ,

Welcome to atlassian community!

Please find the answer inline below.

* Need JQL to get Jira tickets which did not move to a specific status within 24h after creation time

project = "ABC" AND status != Done AND updated > "-24h" AND created = updated

2. Need to all tickets which did not change status to "ready for review" within 24 hours.

project = "ABC" AND status != ready for review AND updated > "-24h"

You might be face some issue in the 1 JQL answer If you faced then Can you please let me know, Is there created date like with 1 week or month then it will find out JQL easy.

Regards,

Sanjen

Please accept the answer If it helps you😊

Murat Seven · Accepted Answer

Hi @Heba Rezk and thanks for your question.

In addition @Sanjen Bariki , you can try this JQL;

status WAS NOT "ready for review" DURING (-1d, now()) and created <= -1d

Hope this helps,

Murat Seven