JQL help to filter for issues created 2 hours ago and the status is still open

[Nathan Yam]

I'm looking to create an automation rule to run every hour that sends a slack notification when there are tickets (type = bug AND status = OPEN) where 2 hours have lapsed since they were created but the statuses still have not changed. 

What is the JQL that I should use as the filter in the Scheduled trigger? 

Also, the Scheduled trigger doesn't allow me to set it to run between 9-5, just select the start date-time and cadence. Unsure if I can use JQL to set this.

[Bibek Behera · Accepted solution]

@Nathan Yam ,

Instead of waiting for 2 hrs and sending the notification on which tickets are created(open). I would rather say create a schedule running for every 2 hours and filter <created >= -2h AND status = "Open">

Just replace the schedule to your need and use the above JQL.

https://www.atlassian.com/es/software/jira/automation-template-library/send-slack

-Bibek

[Nathan Yam]

Thank you @Bibek Behera