How can I search all issues that have time spent + remaining estimate >= original estimate

[Bhavesh Shah]

Looking for a way to search for  time spent + remaining estimate >= original estimate in JQL. When i write something like this, it errors saying Error in the JQL Query: Expecting either 'OR' or 'AND' but got '+'. (line 1, character 184)

 originalestimate < timespent + "Remaining Estimate"

I thought this was very simple and everyone would have wanted this to work. Am I missing something obvious here?

[Joshwa Marcalle]

would recommend a more graphical, simpler solution to this problem.

https://marketplace.atlassian.com/apps/1219348/hours-reports-for-jira?hosting=cloud&tab=overview

Its a cool addon that helps us determine when the estimations of the tasks have gone overboard. 

As far as JQL for this, I do not think it is possible to calculate as you estated but there is a field for this, its called workratio. So you can do this: 

workratio >100

[Bhavesh Shah]

Hi Thanks for the response.

I tried using workratio but the field only takes into account logged hours. I want to do logged + remaining <= Original estimate. Is there any such field?

[Scott Morris]

Ever find a solution here?

workratio catches issues when it's too late

Would be good to catch issues as soon as the remaining is increased (rather than decreased) with a new worklog

[kristina_petrosino]

Would also like a solution as "work ratio" takes into account 'time/estimate remaining' and we dont use that field, so it never calculates correctly for us. I want worklogged (or timespent) is greater than or equal to original estimate.