How to select all tasks which were in a transtion for less than 1min.

Question

I'm struggling to write a JQL that would give me all the tasks moved from one transition to another in less than a minute. On the Agile Kanban Control Chart I can see the aggregated time data is available for each transition.

Is there a way to access the same data from JQL?

so something like this

status changed FROM ("In progress")  TO Done And time spent in status="In progress" < 5m

I've got script runner plugin so maybe a custom JQL script could be written

eXtensi Admin · Answer

OK that's fine but how do I calculate this in my script?

It looks that this plugin does it:

https://marketplace.atlassian.com/plugins/com.googlecode.jira-suite-utilities

I'll have to look at its source

Jobin Kuruvilla [Adaptavist] · Answer

You wouldn't be able to do this by default. But you can write a scripted field for "time in each status" and then search based on that.