Email alert when Work Ratio over 95%

Question

Hi

I want to use script runner to send an email when the work ratio on tickets is over 95%.

I pick the event 'Work logged on Issue' as the event trigger and base it on all projects. The part I am struggling with is the condition. Once the condition is confirmed I can finish the rest of the listener configuration.

The following is the JQL that I want to be triggered as the condition and not sure how to proceed:

"workratio > 95 AND Sprint in openSprints() AND originalEstimate != 0 ORDER BY originalEstimate"

Any help on this would be appreciated.

Thanks

Adam

Rahul Aich [Nagra] · Answer

Can you check if subscription filter can do the job?

Add another clause  in the JQL i.e. updated in past 1 hour; and get the subscription to run every hour.?

Rahul