Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Find issues that ever had a specific status in time

Alain Beaulieu
Contributor
September 1, 2021

We have a free-for-all workflow where every transition is ALL. I suspect that one specific issue status is never used. What JQL can I write to find out how many tickets ever had that status, knowing that this exists (image grabbed from https://www.google.com/url?sa=i&url=https%3A%2F%2Fcommunity.atlassian.com%2Ft5%2FJira-questions%2FHow-to-get-the-time-between-the-workflow-transitions-in-Cloud%2Fqaq-p%2F617957&psig=AOvVaw0Mo6lftMl4T7DoHhPZ0VEU&ust=1630612476667000&source=images&cd=vfe&ved=0CAsQjRxqFwoTCOCkg_7G3vICFQAAAAAdAAAAABAD):

How to get the time between the workflow transitio...

1 answer

1 accepted

8 votes
Answer accepted
Alexander Bondarev
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.
September 1, 2021

Hi, @Alain Beaulieu !

these JQL-query can help you:

status was in (StatusName)
Alexander Bondarev
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.
September 1, 2021

The search-results show you all issues that even been in “StatusName” status.

Alain Beaulieu
Contributor
September 1, 2021

That's too easy. I feel bad for having asked the question to begin with.

Wonderful solution Alexander, thanks very much!

Cheers.

Like # people like this
Alexander Bondarev
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.
September 1, 2021

Everything is fine, our Community is always ready to help!

Suggest an answer

Log in or Sign up to answer