Community
Q&A
Jira
Questions
JQL: How to see issues, which have been in status for more than 1 hour

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

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

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes

Hi @Tima Ushnitsky

This should work:

status = "In Progress" AND not status changed after -1h

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Was this helpful?

Thanks!

Jira

DEPLOYMENT TYPE

CLOUD

PRODUCT PLAN

PREMIUM

PERMISSIONS LEVEL

Product Admin

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

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

1 answer

Comments for this post are closed

Was this helpful?

Thanks!

DEPLOYMENT TYPE

PRODUCT PLAN

PERMISSIONS LEVEL

TAGS

Community showcase

Atlassian Community Events