Need to retrieve issues that status changed in last 30 days

[Rosana Casilli]

Hi All!!

I created an automation that has several conditions taking into account if the status has changed to "presupuestado" after -xd

here the conditions:

1. Status changed to prespuestado after -10d and aplicacion = ESCO Fondos, then add a comment to the issue

2. Status changed to prespuestado after -20d and aplicacion = ESCO Fondos, then add a comment to the issue

3. Status changed to prespuestado after -3d and aplicacion = ESCO Fondos, then add a comment to the issue

The problem I have is that under first condition is also retrieving an issue where status changed 4 days ago and I do not want that to happen. 

And the other problem is, that under condition 2 and 3 it is retrieving also the issue under condition 1 and 2 respectively, and i do not want to happen. 

I need the issues changed x days exactly not all the issues in that period.

Any suggestions? 

Thanks in advance

Ro 

[Bill Sheboy]

Hi @Rosana Casilli 

For a question like this, please post an image of your complete automation rule, images of any relevant actions / conditions / branches, an image of the audit log details showing the rule execution, and explain what is not working as expected.  Those will provide context for the community to offer ideas.  Thanks!

Until we see those...

From what you describe, I am guessing you are using if / else conditions with the JQL condition.  In that case, please try re-ordering your conditions so the most restrictive one is found first, next, and so forth.  For example:

• test for -3d
• test for -10d
• test for -20d

Also please note: with the CHANGED operator, if your issues have repeatedly transitioned to a that Status value, there could be multiple matches for different expression timeframes: -3d, -10d, and -20d.  And so ordering the tests the way you want to check them is important.

Kind regards,
Bill

[Kalyan Sattaluri]

Hello @Rosana Casilli 

Have you tried to give it the lower boundary as well, like below:

aplicacion = "ESCO Fondos"  AND

(Status changed to prespuestado after -10d ) AND 

(Status changed to prespuestado Before -9d )