Advanced search for time tracking fields

Question

Hi all! I kindly ask for your help!

I need to make a report that includes all the Jiras from last year that their ‘logged’ field is greater than their ‘estimated’ field.

I found information that needed to use 'originalEstimate' for estimates, 'remainingEstimate' for remaining and 'timespent' for logged work.  But when I put 'timespent' I see that needed to put time, the system doesn't what to compare logged time with estimated time.

I wrote:

"Product L1 Name" ~ Euclide AND created > startOfDay(-365d) AND timespent > originalEstimate

and got: "The value 'originalEstimate' for field 'timespent' is invalid. Please specify a positive duration format; for example: '1h 30m', '2d'.".

Thanks in advance!!!

Mohanraj Thangamuthu · Answer

Hello, Good day. Please check if the following option helps. You can try the timespent value in minutes

createdDate >= 2022-10-24 and timespent >= 10