Find tasks with Spent time > Estimate

Answered
Hi,

I was trying to achieve it for some time. I need to filter tasks that have exceeded estimate. Both spent time and estimate fields are saved as periods. Can someone help me ?
4 comments
Comment actions Permalink
Official comment

Hello, unfortunately you can't perform arithmetic operations on period fields yet. Please try to wrap the value using one of our special methods, for example, `getPeriodFieldValueInMinutes`: https://www.jetbrains.com/help/youtrack/incloud/2017.1/Workflow-String-Date-Operations.html#getPeriodFieldValueInMinutes

Please let us know if you have any further questions, thank you.

Comment actions Permalink

Hi there, im looking for a similar query. 

I need all tasks with a spent time > 0. (Spent time: >0 does not work)

Maybe somebody can help me.

Thx

0
Comment actions Permalink

Hello and thx for your feedback. I understand that a period field does not perform arithmetic operations.

But maybe u can help me to understand, how can i get a list of tickets with spent time >0? In your description i should firstly create a workflow with the command u postet me "getPeriodFieldValueInMinutes" and tag the tickets with "nothing spent"? After it i can filter the tickets with: show me all tickets which have the tag "nothing spent"? Is that the solution u meant?

Because this command does not work in the search console. Or is there a differnt way?

Thx

0
Comment actions Permalink

Hello Sebastian, I'm sorry for being misleading, of course the solution that I suggested is applicable to workflows only.

In the search we don't have such functionality yet, please vote for this feature request in our tracker: https://youtrack.jetbrains.com/issue/JT-12841

Let me know if you have any questions.

0

Please sign in to leave a comment.