Automation does not work as required

[Dewa Fakha Shiva]

Hi everyone, I have an issue about the automation for Jira Software.

I have read similar case like the link below:

https://community.atlassian.com/t5/Jira-Software-questions/Why-are-no-actions-being-performed-when-my-JQL-finds-issues-when/qaq-p/2431706

But I still have no idea why my automation did not working as required.

Here are some screenshot to help checking the situation:

1. This is the rule for the automation

I tried to run this automation every 10 minutes.

The JQL query that I run is:
status = "Production" AND status changed to "Production" BEFORE -2w

as per my understanding and explanation from ChatGPT, this query should be showing all of the issues that in the Production column and move to the Production column after 2 weeks.

and as you guys can see, when I validate the JQL query, it showing 134 issues found, I also tried in the filter functionality and see the same result.

2. This is the audit log for that automation

The audit log showing there is no action performed, I don't know why.

Can somebody help to get me out of this situation? thank you in advance.

[Walter Buggenhout · Accepted solution]

Hi @Dewa Fakha Shiva,

The problem is exactly what the message in the audit log says: you have selected the  checkbox just below your query to

Since you are trying to close issues that have not been changed for 2 weeks, none of your 134 issues have been updated recently. So uncheck this box and your rule should run.

On a small side note about the filter itself: this query does not show all the issues that moved to the Production column after 2 weeks, but the ones that were moved more than 2 weeks ago. That may just be a typo, as I believe this is indeed what you want, but just making sure ...

Hope this helps!

[Dewa Fakha Shiva]

Hi @Walter Buggenhout ,

Thank you so much, you help works like a charm!

Yes, for the JQL query, I'm aware of it, but as long as the condition match with my needs, I will go with it.

Once again, thank you!

[Geethanjali Katagani]

Hi @Dewa Fakha Shiva ,

I hope this email finds you well. I noticed that you have selected the checkbox in the schedule. However, when the checkbox is selected, it triggers automation to run only once for filtering issues. Therefore, I recommend unchecking the box.

Thank you,

Geethanjali

[Dewa Fakha Shiva]

Hi @Geethanjali Katagani ,

Yes thank you, it works!