How to filter tickets that stayed in a status for a given time

Przemek Sech November 7, 2017

Hi,

My goal is to filter out tickets that stayed in "Peer Review" status for over 3, over 4, over 6 and over 10 days during a month.

I am playing with status changed but with no success.

status changed from "Peer Review" AFTER startOfDay(-1d) BEFORE startOfDay() 

gives me tickets that altered the status yesterday but that is not what I am looking for.

Lists should contain unique tickets so if a ticket stays in status over 6 days it should be not present in "over 3" and "over 4" days lists.

Please help.

Cheers,
Przemek

2 answers

1 vote
Przemek Sech November 7, 2017

I think I am getting closer

status changed from "Peer Review" DURING (startOfMonth(), endOfMonth()) AFTER -1d BEFORE 6d
0 votes
Gregor Kasmann_Actonic
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2017

It is not exactly what you are looking for, but you can view the transition time per status per issue by installing Suite Utilities for Jira (JSU) https://marketplace.atlassian.com/plugins/com.googlecode.jira-suite-utilities/server/overview

Suggest an answer

Log in or Sign up to answer