JQL Find all sub tasks that have been inprogress for longer that the estimate or remaining hours

Greg Cook_24f4g4

HI.

Im trying to see which tasks are currently in a state of in progress but have been so for a time frame which is larger than the Estimated Time or Renaming time on the Task

This can be currently in a particular start ( eg how many hours has it been in progress )

Or can be retrospective view ( how many hows did it sit in in progress and its now in a different state ).

I have tasks which have an elapsed time of Days but actual effort recorded as hours and i need to try and understand why we are seeing this.  Being able to see this would allow me to open conversations with the team.  

I believe the CHANGED keyword could work, but i guess i need to know where something has changed from in progress to DONE or Closed where the duration was great than estimated? 

 

i cant use a plugin for this.  

Thanks

 

Alexey Matveev

Hello,

You can not write such a JQL query out of the box. You would need to write your own JQL function. You can do it with such add-ons as Power Scripts or ScriptRunner.

You can find more info on how to develop your own JQL function, using Power Scripts here:

https://confluence.cprime.io/display/JJUPIN/JQL+Support

There is a 30 days trial period. You can try it for free.