Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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"



1 answer

1 accepted

2 votes
Answer accepted


Maybe you could write a JQL query like this:

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

@elisabethesbjornsson and @Alexey Matveev _Appfire_ could I ask a question to this topic an I hope you are both still users. What are the different effective means to display this JQL query? 

Like Kelsey McDowell likes this

@elisabethesbjornsson @Heinrich Graupner @Heinrich Graupner 

I'm also curious if and how you displayed this JQL query.

@Kelsey McDowell 

I displayed the JQL query using Custom Charts for Jira. Works very well! 

@Heinrich Graupner @Kelsey McDowell 

I am using this as a quick filter on the board. When applying that quick filter I can see if there are issues that might be stuck for too long in the same column.

The full JQL for the quick filter I am using:

NOT (status changed during (endOfDay(-2), now()) OR status changed during (-4d, endOfWeek(-1w)) ) AND status not in (New, "To Do", "On Hold", "Test on PRD", Closed)

The "during (-4d, endOfWeek(-1w))" part takes into account the Thursday and Friday events when getting back to work and check the board on a Monday.

@Heinrich Graupner  We also have custom Charts. Could you please share a screenshot of your configuration? We'd greatly appreciate it.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you