It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I show days spent in specific status for an issue using JQL? Edited

I would like to use JQL to show days spent in specific status, in seperate column.

Is this possible?


Using cloud version.

1 answer

0 votes
nic Community Leader May 15, 2017

JQL is not SQL, it is for finding issues, not telling something what to display.

You should be able to construct JQL to find the issues you want to report on, but the real challenge is going to be finding something to show you the data you want from the issues.  There is a "time in status" report, which I think will try to tell you something, but I have not found it to be that useful myself.

Thanks for the answer.

That's the same, I've also experienced.

What I want is something like in the the agile control chart, but only for specific issues

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Calling all Jira Cloud users! Give us feedback on our exploration of a new navigation.

Hi everyone! My name’s Matt and I’m a product manager at Atlassian. I work in the navigation & findability space for all our Jira Cloud products. We’ve been working on trying to improve the exp...

1,147 views 19 12
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you