Create an email automation when status has not changed in x amount of days

[Michelle Vita]

Hi, I am trying to create an email automation where I receive a list of cards that have been in the same status for x amount of days.  I am creating the JQL but I am receiving 0 issues when validating even though there should be multiple.

Any help is appreciated! thanks 

[Evgenii]

Hi, @Michelle Vita 

Welcome to Atlassian Community

You can try such JQL

project = ZZZ AND status changed BEFORE startOfDay(-45d)

It will show all issues, where status was not changed for 45 days

[Trudy Claspill]

Adding to this...

Is there a specific reason you want to use an Automation Rule for that? You could alternately create a Saved Filter and set up a Subscription to that filter to send you the results on a schedule.

https://support.atlassian.com/jira-software-cloud/docs/manage-filters/#Subscribe-to-a-filter