nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Jobin Kuruvilla [Adaptavist]

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

All comments

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?

Jobin Kuruvilla [Adaptavist]

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

David Zuccaro

Thanks, that is just what I needed.

Alex Gubar

Hi David,

Script Runned and

AND issueFunction in expression("","timeoriginalestimate &lt; timespent")

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud