Filter where logged time exceeds estimated time.

[David Zuccaro]

Hi,

How can I create a filter that reports all tasks (not closed) where logged time exceeds estimated time?

Thanks,

David

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

Actually, you can use workratio in JQL. See the examples.

[David Zuccaro]

Thanks, that is just what I needed.

[codelab expert]

This is not possible using JQL. The fields timespent and timeestimate require a time duration value. So you can't compare this fields.

Possible solutions:

[1] write your own plugin

[2] make excel export and compare this values in excel

[David Zuccaro]

Can't JQL create a join to the tempo data?

[David Zuccaro]

Is it not possible to do a "JOIN" between the task table and the relevent tempo table in JQL? Or do I misunderstand the back end of JIRA?

[Alex Gubar]

Hi David, 

Script Runned and 

AND issueFunction in expression("","timeoriginalestimate < timespent")