Advanced JQL to highlight stalled issues on a wallboard.

Has someone written a JQL query where it shows the following:

* An issue(s) have been in a status = "In Progress" since "2012/10/20"

I just put a date in there, but it should be able to work with the startofWeek/endofWeek/etc functions.

Basically what we are trying to do is highlight any issues that have stalled out and put them up on our wallboard. The problem we are having is if a card has moved in and out of "In Progress" the BEFORE JQL picks up on those dates and it is giving us false positives.

Thank you for the assistance.


Jeremy Neuharth | Founder


4 answers

1 accepted

0 votes
Answer accepted

I don't know if there is a direct query but there is certainly a workaround. Create a filter for issue where status was changed after a date.

status changed after "date"

And then query for issue not in that filter.

filter != "filter I created above"

We where trying to keep the logic out of the wall board code, although that would work.

Does anyone have an example JQL statement that selects issues in a status, such as "In Progress," that are concered stalled? As I metioned above, our goal is to call attention to issues that are not moving through the workflow.


Jeremy Neuharth | Founder



Note that the "pips" shown at the foot of each card on the rapid-board indicate that cards duration that status. The more pips, the longer it has spent in that statis. Mouseover, get more info.

As a quickfilter option you could try:

updated > startOfDay(-3)

I.e: show issues that haven't been updated in more than 3 days.

We call this filter button, "the button on shame" :)


We actually use the "pips" when we look at the KANBAN version of the taskboard. With that said our team is large enough with things fairly broken down that we can't get the needed information (thumbs up or down) on a single big screen that is always updated for the team. So, I basically want the logic of the "pips" (which is just how long it is in the current status) and show any issues over X old in that status.

That is why I am looking for the JQL to pick them off the board and show in a different way on a wallboard that we have developed.


Jeremy Neuharth | Founder


Found this thread when I was trying to develop my solution to this problem which I have attached below. This works well for us with three week cycles. I would probably shorten it a little if we were only in 2 weekly iterations.

image2016-6-21 8:58:24.png

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 14, 2019 in Jira

Updates to give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

584 views 1 15
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you