Forums

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

JQL: How to see issues, which have been in status for more than 1 hour

Tima Ushnitsky November 14, 2022

I need to return tasks that are "in progress" status  for more than 1 hour.

1 answer

0 votes
Tim Perrault
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 14, 2022

Hi @Tima Ushnitsky 

 

This should work:

status = "In Progress" AND not status changed after -1h
Tima Ushnitsky November 14, 2022

Hi @Tim Perrault 
this query returns tasks with status "In Progress", I need to return tasks that have been in this status "In Progress" for more than 1 hour

Tim Perrault
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 15, 2022

I'm not sure I understand. I thought you wanted all tickets that are in "In Progress" and have been there for at least an hour?

Tim Perrault
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 15, 2022

I looked at it again and I think Jira is rounding numbers. Try this:

 

status = "In Progress" AND not status changed after -60m

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