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

Question

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?

kristina_petrosino · Answer

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.

Scott Morris · Answer

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

Bhavesh Shah_sk4zlv · Answer

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?