Is it possible to select all issues with timespent > timeoriginalestimate via advanced searching?

[Christian Groth]

In the documentation for the advanced-search there is only an example for timespent-search where tmespent is compared with an amount ot hours (e.g. 5h). Is it possible tgo slect all issues with timespent > timeoriginalestimate?

[Alex Taylor · Accepted solution]

Seach for 'workRatio > 100'. That will return all issues whose timespent is greater than the original estimate.

[Christian Groth]

Allex, thanks for your hint!

[Art B]

I am looking to query tasks which have Remaining greater than Estimated. WorkRatio >100 only retursn items where Logged > Estimated. How can I find task that our Remaining > Estimated?

Thanks

[Aditi Mishra]

Very helpful

[Parisa Khoshniat]

this really work. Thank you 

[Art B]

I am looking to query tasks which have Remaining greater than Estimated. WorkRatio >100 only retursn items where Logged > Estimated. How can I find task that our Remaining > Estimated?

[Jobin Kuruvilla [Adaptavist]]

Yes. Use workratio as mentioned here: https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-WorkRatio

[Christian Groth]

Hi Jobin,

thanks for your answer.

I tried a very simple search: timeestimate < timespent

But this didn't work, Jira prompted the error-message

The value 'timespent' for field 'timeestimate' is invalid. Please specify a positive duration format; for example: '1h 30m', '2d'.I giot the g

In the documentation there is only an example where timespent is compared to a specific value (e.g. 5h).

Do you have another hint for me?

[Jobin Kuruvilla [Adaptavist]]

I asked you to search using workRatio. Did you read the doc?

[Christian Groth]

Sorry, I should have read your first answer more carefully! With using the workratio it works fine!

Thanks.