The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

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 Champions.
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 Champions.
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 Champions.
September 1, 2021

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