Creating Filter based off Sprint Insights

[Nicholas Davidson]

I'm trying to create a filter to show all our Sprint Issues that are listed in insights as stuck. I see how to filter based off of a flagged status but not if a ticket has been stuck for a certain amount of time in a certain status. For instance in our Sprint Insights it shows that we have some tickets that are stuck due to most of our issues moving out of In-Progress within 2 das, is this able to be filtered?

[Walter Buggenhout]

Hi @Nicholas Davidson and welcome to the Community!

JQL (Jira Query Language) does allow you to do history searches on status. It will be important that you define up front what you consider to be stuck or out of the ordinary.

To build upon your example, suppose you want to find the issues that are in progress and are in that status for more than 2 days, you could use something like this:

Sprint in openSprints() AND Status = "In Progress"
AND Status CHANGED TO "In Progress" Before startOfDay(-2)

Hope this helps!