Forums

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

JQL that shows the issues that haven't been transitioned in 24h

Jorge Mora July 22, 2019

Hello!

I need a query to provide me with this information to later launch an email notification.

Thanks!!

3 answers

0 votes
Haran Kumar
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.
July 22, 2019

Hi @JMora ,  you may try this for your requirement, 

!status changed AFTER '-24h'

0 votes
Tarun Sapra
Community Champion
July 22, 2019

Hello @Jorge Mora 

Issues which haven't been transitioned in last 24 hours

!(status changed AFTER '-24h')
0 votes
Thomas Deiler
Community Champion
July 22, 2019

Dear @Jorge Mora ,

this JQL would return all issues that were not transition to status "Closed" or "Done"  in the last 24h:

!(status changed TO (Closed,Done) during (-24h, now()))

So to catch up all, you need all possible statuses of all issues you would like to catch up and add them to the '(Closed,Done)' brackets.

So long

Thomas

Haran Kumar
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.
July 22, 2019
'

Suggest an answer

Log in or Sign up to answer