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 past 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

3 answers

Hi @Vinod Madhappan,

The 2nd one is correct. With some minor tweaks:

Project = "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

Updated < -4h means last update smaller than 4 hours ago

Thanks @Walter Buggenhout _ACA IT_ : The use of  -(Minus) symbol confuses. When i try this  updated > 4h am not getting any result whereas we get results for  updated < -4h

Both are same right? why is not working with updated > 4h ?? @Walter Buggenhout _ACA IT_ 

I am resuming your last question in here, @Vinod Madhappan

If i try the same with updated > 4h , the query does not fetch me any result where as when i try with updated < -4h am able to get the result. Both are same right?

Why does it not work with  updated > 4h ?? @Walter Buggenhout _ACA IT_ 

Following the same example we used before, let me lay out the example again:

  • We'll assume again that now is 9 PM
  • 9 PM + 4 hours (4h) would be 1 AM the next day (this is in the future)
  • Your ticket was last updated at 4 PM, which is before 5 PM today

As no tickets can be updated at a point in time that is still to come, your query returns no results.

Jack Community Leader Nov 25, 2020

well > 4h is a Project Managers Dream! That will tell you which issues will be update in the future 4 hours from now and beyond.

future.jpg

Like # people like this
Dave Liao Community Leader Nov 25, 2020

@Jack - with machine learning, I'm sure it will be possible to have predictive JQL results. Is there a JAC ticket for this? I'd vote that up with my many Atlassian IDs. 😏

#jokes

@Walter Buggenhout _ACA IT_ : Am little confused now with this reply.

"Updated < -4h means last update smaller than 4 hours ago"

 

I need to get a result of tickets which is not updated in the past 4 hours. For ex: If a ticket is updated 4 PM, and if i run a query at 9 PM i need to have that ticket in my query.

Yes. That means that the update was longer in the past than 4 hours ago, right?

  • In your example, let's assume that now is 9 PM
  • 9 PM - 4 hours (-4h) would be 5 PM
  • Your ticket was last updated at 4 PM, which is before 5 PM

=> updated < -4h will show you the ticket. Updated is the system date of the last ticket update.

@Walter Buggenhout _ACA IT_ : Thanks the -(minus) symbol confuses.

 

If i try the same with updated > 4h , the query does not fetch me any result where as when i try with updated < -4h am able to get the result. Both are same right?

Why does it not work with  updated > 4h ?? @Walter Buggenhout _ACA IT_ 

Suggest an answer

Log in or Sign up to answer
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