JQL BEFORE predicate and relative formats

Question

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?

Nic Brough -Adaptavist- · Answer

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.

angel · Answer

Nic,

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

Nic Brough -Adaptavist- · Answer

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"