Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL for tickets did not change status for 24 hours

Heba Rezk
Contributor
November 10, 2023

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.

2 answers

2 accepted

5 votes
Answer accepted
Murat Seven
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 10, 2023

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 

1 vote
Answer accepted
Sanjen Bariki
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 10, 2023

Hi @Heba Rezk ,

 

Welcome to atlassian community!

Please find the answer inline below.

  1. 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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 10, 2023

 ..

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events