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

[Vinod Madhappan]

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

[Vinod Madhappan]

can someone help me with providing the right answer asap

[Gokce Gursel _Snapbytes_]

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

[Zoryana Bohutska _SaaSJet_]

Hi @Vinod Madhappan 

Optionally, you can try SLA Time and Report app. It let you set a timer, time limits and automate actions for exceeded issues.  Add-on lets you select issues by any issue field parameters: project, status, priority, assignee, etc.

Best Regards

Zoryana

[Gokce Gursel _Snapbytes_]

Hi @Vinod Madhappan ,

Jira's built in capabilities are enough for this requirement. You don't need an add-on.

You first query is correct.

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

[Daniel Ebers]

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