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

[Greg Cook]

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.

[Greg Cook]

Hi and thanks for the comment.

as mentioned i cant use a plugin for this, i am in a corporate environment where i can just install a plugin. 

However we do have script running and if you are able to provide some guidance around the jql using script runner that would be appreciated.  

Im comfortable with jql, however im not yet sure ive established how to do what i want using that.  Failing the above i can resort to the rest API and write some code to export data, however i want to avoid that for now

thanks

[Alexey Matveev]

You can also develop a JQL function with ScriptRunner. But I do not have a script, which fits your requirements.

[Greg Cook]

can you point me to a document that shows how to develop functions with Script Runner ( assuming im not a Jira Admin )

[Alexey Matveev]

You  can not develop a JQL function, if you are not a Jira admin. 

https://scriptrunner.adaptavist.com/latest/jira/custom-jql-functions.html