Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL is not less than or equal to

HH
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.
March 6, 2019

Hi, 

I want to do a JQL query where tickets that haven't been updated in 7 days are captured. I want to ensure that anything that's older than 7 days and hasn't been updated doesn't trigger my automation. If I don't include that I've found that it triggers the rule every night and spams me with emails!

So I went for this: 

Updated <= -7d AND Updated !<= -8d AND status = "Waiting for Customer"

As I was hoping I could get the logic to work like !< (Not less than) Transact-SQL but it hasn't worked. Can anyone help me out? I'm going JQL crazy!

1 answer

1 accepted

3 votes
Answer accepted
Kian Stack Mumo Systems
Community Champion
March 6, 2019

This would be the closest to what you are looking for: 

Updated <= -7d AND Updated > -8d

HH
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.
March 7, 2019

Thanks!

Suggest an answer

Log in or Sign up to answer