How can I get the time since latest transition in JQL?

elisabethesbjornsson

I want to know the time in a certain column since the latest transition was made, but can't find how.

The reason for this is that the issue might have had the same status before, but I want to know for how long the issue has been in a certain column the second time.

Using this JQL will show the wrong issues, since some of them might have been in Internal test before, but for the second time it's only been there for 1 minute and then it shouldn't be shown with this filter.

status changed to "Internal Test" before -2d AND status = "Internal Test"

 

 

Alexey Matveev

Hello,

Maybe you could write a JQL query like this:

not (status changed after -2d) AND status = "Internal Test"