Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

JQL for tickets did not change status for 24 hours

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

4 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.
Nov 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.
Nov 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.
Nov 10, 2023 • edited

 ..

Suggest an answer

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

Atlassian Community Events