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 ?
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 ?
Please sign in to leave a 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.
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
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
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.