Filter JQL that show issues that passed a certain time of hours or days in a state

[Giovanni Cantero]

How to do a filter JQL that only show all issues that passed five hours in the same state.

For example: If we have 6 issues, and two of them are there for "seven hours". We want to see only these two issues that passed this period of time (7 hours).

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

Try the following:

NOT status CHANGED AFTER -5h

[Giovanni Cantero]

Thank you, but the query show issues 45 seconds before the established time in case of minutes use.

Do you know a solution for that?

[Giovanni Cantero]

There are a Examples of the result.

[Giovanni Cantero]

[Jobin Kuruvilla [Adaptavist]]

Is that a custom field you created? You can cross check the time with the time in the "History" tab. JIRA should be showing the search results based on the correct time.