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

Vinod Madhappan November 25, 2020

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

5 answers

0 votes
Junie Teudjeu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 2, 2024

how schould a comment be sent to the assignee automatically

 

0 votes
Daniel Ebers
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.
December 5, 2020

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

0 votes
Gökçe Gürsel {Appfire}
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
November 25, 2020

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

0 votes
Zoryana Bohutska _SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
November 25, 2020

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

0 votes
Vinod Madhappan November 25, 2020

can someone help me with providing the right answer asap

Gökçe Gürsel {Appfire}
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
November 25, 2020

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events