JQL works with "m" but not "h".

Question

I have a scheduled automation which runs a JQL search.  The intent is to identify issues which have been in a certain status for more than 12 hours.  It then triggers a slack push notification.  I use the following JQL "status = "To Be Reviewed" AND status was "To Be Reviewed" before -12h" and run it every 5 minutes.  When I test the automation by setting the time to "before -1m", it runs fine.  When I change nothing but that field to -12h, we never get the push notification.  Can't figure this out....  welcome help!

William Negley · Answer

This remains a very strange issue.  Somehow the switch from "-1m" to "-12h" (all else remaining the same) impacts the push to Slack.  It works as expected consistently when set to -1m.  Then I shift to -12h and it doesn't push.  I'm changing to -720m to see if that does something...

Walter Buggenhout · Answer

Try what happens if you turn that option off. It does not return issues that are new, as it says it returns issues that have changed since your rule has run for the last time. Since you are basically searching for issues that have not changed (they are in the same status for over 12 hours because no one has touched them), that might be your problem.

William Negley · Answer

The query validates.... Would it still cause a problem?