Forums

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

JQL BEFORE predicate and relative formats

angel
Contributor
August 4, 2014

I'm trying to find issues in certain status for which the transition took place before X hours/minutes etc.

status = "STATUS ABC" and status changed to "STATUS ABC" BEFORE -2h

The syntax seems syntactically valid but I don't get the expected results. Any ideas?

1 answer

0 votes
Nic Brough -Adaptavist-
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.
August 4, 2014
Dates and times are numbers. So try greater and less than symbols < and >. I think your clause will be status changed to x > -2h ( that means "a time greater than two hours ago" or "in the last two hours"
angel
Contributor
August 4, 2014

Nic,

the comparison operators "<" , " >", etc. are not valid for the "CHANGED" operator, only BEFORE or AFTER

Nic Brough -Adaptavist-
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.
August 4, 2014

Bother, sorry, I forgot that, I was looking just at the date/time element, it had just come up at the office.

Before and after only accept absolute date/time as far as I know.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events