Need to get results of tickets not updated in the last 4 hours

Question

I need to write a JQL ticket to get the results of tickets which has no updates in the last 4 hours.

project in ("ABC") AND status not in (Closed, Cancelled) AND priority in (Blocker, Critical) AND updated > -4h AND type not in ("Deployment Request", "Operational Request") ORDER BY updated DESC

Please help me if this query is correct?

Or it should be

project in ("ABC") AND status not in (Closed, Cancelled) AND priority in (Blocker, Critical) AND updated < -4h AND type not in ("Deployment Request", "Operational Request") ORDER BY updated DESC

Junie Teudjeu · Answer

how schould a comment be sent to the assignee automatically

Daniel Ebers · Answer

Hi Vinod,

"updated > -4h" will show you issues that have been updated within the last 4 hours.
"updated < -4h" whill show you issues that do not have been updated within those 4 hours.

Please be noted there is meanwhile an accepted/recommended answer:

https://community.atlassian.com/t5/Jira-questions/Need-to-get-results-of-tickets-not-updated-in-the-past-4-hours/qaq-p/1542576

It looks like this has been a double post.

Cheers,
Daniel

Gökçe Gürsel {Appfire} · Answer

Hi @Vinod Madhappan ,

Your query is correct. You don't need an additional tool for this.

project in ("ABC") AND status not in (Closed, Cancelled) AND priority in (Blocker, Critical) AND updated <= -4h AND type not in ("Deployment Request", "Operational Request") ORDER BY updated DESC

Cheers,

Gökçe