Why isn't the Changed operator working?

Elsie Carroll

I'm trying to run a scheduled automation where, if a case has been in a certain status for more than a week, it makes a comment and changes the status to a different one.  The portions for specifying the statuses, the project, and the transitions itself are working, but it's applying to everything instead of just cases that have been in that status for more than a week.  My current wording is this: 

status changed before "-1w"

 

I have tried it with startOfDay("-1w"), now(), and after instead of before, but it either triggers daily on everything or it isn't working at all.  Where have I gone wrong?

Trudy P Claspill

Hello @Elsie Carroll 

Welcome to the Atlassian community.

You are made two different statements of problems in your post:

"it's applying to everything instead of just cases that have been in that status for more than a week."

"but it either triggers daily on everything or it isn't working at all."

The triggering of a scheduled rule is based on the Occurrence settings of the Scheduled trigger, not based on your JQL statement. So if the rule is "triggering" daily that is a different problem than if it is operating against issues other than the ones you intend to affect.

Have you tested the JQL through the Filters > Search Work Items screen? If you have not I recommend you do that to work out the JQL statement before trying to use it in an Automation rule.

It will enable us to help you more effectively if you show us screen images of your entire automation rule, the details of the trigger, and any component where you are trying to use the JQL statement. Sharing all the details from the rule execution Audit Log will also be helpful.