Forums

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

JQL logic to check for created > 7d

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 1, 2019

Hi, 

I want to check whether a ticket has been waiting for the customer for more than 7 days. I've got the following JQL, which I thought was checking whether it had been updated in anything more than or equal to 7 days, however it's returning a ticket that was created today!

(project in (10300)) AND ((Updated >= -7d AND status = "Waiting for Customer"))

So I tried to alter it to include a creation date: 

(project in (10300)) AND ((created > -7d AND Updated >= -7d AND status = "Waiting for Customer"))

However neither of these are working. Hoping someone can see where I'm going wrong! 

1 answer

1 accepted

0 votes
Answer accepted
Tuncay Senturk
Community Champion
March 1, 2019

Hello Hollie,

If you use updated >= -7d it returns issues that are updated within last seven days. 

So, you should use <=

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 1, 2019

Thanks! JQL blindness had set in - this was driving me mad!

Tuncay Senturk
Community Champion
March 1, 2019

Yeah, it happens sometimes and it may take hours to rescue from that blindness.

Suggest an answer

Log in or Sign up to answer