Email notification when logged work= estimated time

Question

Dear Atlassian community,

I´m looking for an Automation rule to send out an email notification when logged time in a ticket is >= the initial estimated time. I tried with some smart values but I wasn´t successful yet.

Is there anyone with a helpful tip?

Thanks in advance
Sven

unknown · Answer

Hi @Darryl Lee 
Thank you for your information!
I have now managed to create a good query/filter and that is that a mail will be sent if the effort of the remaining time is less than 20% of the original effort.
Problem is that the rule does not take effect if the user documents the actual effort, but at the same time increases the remaining effort so that it is >20% of the original effort.
So I would like to combine the first if condition with another condition "field remaining time was edited". Can you tell me if and how this can be done?

Thanks in advance
Sven

Darryl Lee · Answer

Only tested this in Cloud, but it looks like at least in version 7.3.4 for Server, the field is also timeestimate.

Darryl Lee · Answer

Ah, sorry, you're right. You're not trying to sum-up child tickets.

So "ist gleich" means "equals"?

So remainingEstimate is not actually a valid Smart Value. I looked at the REST API for one of my tickets, and found that the field name is actually timeestimate.

You can do this too, and it is very useful:

https://YOURSITE.atlassian.net/rest/api/2/issue/YOURTICKET?expand=names

And in the response, I see:

"aggregatetimeoriginalestimate": 3600,
    "timeestimate": 2700,

(Values are returned in seconds, so then, my original estimate was 60m, and I have 45m left on this ticket.)

Remaining Time/Estimate cannot be negative, so then the rule is actually pretty simple: