my goal is to have a list of the JIRA tickets that are not moving from one lane to another so that I can intervene on those tickets and check if impediments, difficulties or issues are up in place.
So basically I would like a query to create a JIRA filter that sort tickets depending on some ticket information, for example
- sort the amount of time since last date status changed
- sort the amount of time spent in the status "IN PROGRESS", in "REVIEW" or in "TESTING" (where IN PROGRESS, REVIEW, TESTING are status within my JIRA project)
If it is not possible to create a specific query/filter, which could be the other solutions? I am already aware of the grey-gradient-coloured-dots in the bottom part of the ticket within the Active Sprint view. But I prefer to visualize this information out of a query, for example for a dashboard widget.
Thanks in advance