How to create overdue task filter without using duedate

[Sannette]

Hello

I'd like to create a filter that will identify when more time is spent on a task than the original estimate.

So far I got to the below query :

project = MSA AND fixVersion = "Sprint 7" AND status = "In Progress" AND issuetype = "Technical task" AND ( (remainingEstimate + timeSpent) > originalEstimate )

Once the filter has been setup notifactions will be sent out to the relevant people.

Please help !

Thank you

Sannette

[JamieA]

There is some info on this here: https://studio.plugins.atlassian.com/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-expression%28Subquery%2Cexpression%29

Not applicable to OD though. Timothy is right, but it doesn't take into account the remaining estimate.

[Timothy]

Have you tried the JQL's workRatio?

Work Ratio is calculated as follows: workRatio = timeSpent / originalEstimate) x 100