nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

API request to get the time an issue spent in a particular state

Juan Pedro Silva

Hi!,

I´m working on JIRA Cloud and I would like to generate a report which shows the time individual issues spent on a determined state (e.g., time "Ïn Development", in "QA", etc.).

Is there anything available by default in the API, or some sort of query that I could build?

Thanks in advance.

Regards,

Accepted answers

Bill Sheboy

Hi @Juan Pedro Silva -- Welcome to the Atlassian Community!

Regarding measuring the time in status, there is no out-of-the-box way to do this with JIRA cloud. To have this capability, you could:

Buy a marketplace add-on product,
Export the system logs using a webhook and parse them in a log parser, or
Build your own solution using custom fields and automation rules.

There are several community posts about the last two methods, and I expect that one or more marketplace vendors will respond to your question with add-ons you can purchase.

Also, there are several suggestions to add cycle and lead time measures to JIRA, which you can review and vote for on these items:

https://jira.atlassian.com/issues/?jql=project%20IN%20(JRACLOUD%2C%20JSWCLOUD)%20AND%20resolution%20%3D%20Unresolved%20AND%20summary%20~%20%22cycle%20time%22%20AND%20summary%20~%20report%20ORDER%20BY%20Key

Best regards,

Bill

All comments

Bill Sheboy

Hi @Juan Pedro Silva -- Welcome to the Atlassian Community!

Regarding measuring the time in status, there is no out-of-the-box way to do this with JIRA cloud. To have this capability, you could:

Buy a marketplace add-on product,
Export the system logs using a webhook and parse them in a log parser, or
Build your own solution using custom fields and automation rules.

There are several community posts about the last two methods, and I expect that one or more marketplace vendors will respond to your question with add-ons you can purchase.

Also, there are several suggestions to add cycle and lead time measures to JIRA, which you can review and vote for on these items:

Best regards,

Bill

Juan Pedro Silva

Thanks, Bill! Will sure add my vote to those suggestions.

I will research the use of listeners for building it ourselves too.

Regards,

Zoryana Bohutska _SaaSJet_

Hi @Juan Pedro Silva

If you need to get this data now, you can try a solution from the Atlassian Marketplace.

For example, one of them is Time in Status for Jira Cloud. It generates reports which show the time individual issues spent on a determined state like Development, QA etc.

Also, this app lets you view other types of reports useful for managers (assignee time, average time, etc.) All data are available for chart view and as the gadget for the Jira dashboard.

Hope this info will be useful for you.

Regards,

Zoryana

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software