Help with jql query

[Leena Siddamshetty]

I need some help with the jql query for below scenario please. Trying to create an automation rule:

ABC type tickets with XYZ as Sev0 to send reminder to assignee and eng-owner/lead in Jira if ABCD is EMPTY for greater than 24 hours.

project=XXX and issuetype = ABC and "XYZ[Radio Buttons]" = "SEV0 Critical" AND "ABCD" is EMPTY

Not sure how to include 24 hours part.

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Date/Time fields in Jira are "epoch" time;  the number of seconds elapsed since a fixed date (00:00:00 UTC on 1 January 1970 on Unix-like systems) and then every millisecond after adds 1 to it.  (Yes, next Y2K problem lands in 2038...)

So when you're comparing date and date/time, you always know that the larger the number, the later it is.

While Ashley was on the right track, they got the comparators wrong.  "Resolved >= 24h" means "Resolved after this time tomorrow"

I would use "and Updated >= -24h"  which means "issue was not updated in the last day"  (You could also ask it for -1d)

But that only looks at any updates, you're going to struggle to limit it to just that field.  You're already looking at it being empty, and "issue has not been updated for a day" might be good enough for your need.

[Ashley Hudson]

Heya @Leena Siddamshetty ,

So in terms of adding the 24hrs, just add the following snippet into your JQL:

resolved >= 24h 
or
EMPTY >= 24h

Let me know if this helps! :)

Kind Regards,

Ashley Hudson

[Leena Siddamshetty]

Thanks Ashley but I am looking for ABCD field not updated or is empty for more than 24 hours.

[Leena Siddamshetty]

that doesn't work Ashley :(