Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

4 answers

can someone help me with providing the right answer asap

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

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

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
Daniel Ebers Community Leader Dec 05, 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

Suggest an answer

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

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you