how can i get Time in Status without any plugin?

[Amelie Allen]

I need Time in Status without any plugin. Can i get it with JQL?

[Valeriia_Havrylenko_SaaSJet · Accepted solution]

Hi @Amelie Allen  👋

Unfortunately, there is no way you can find with native features, but you can achieve it with JQL. You can find a suitable JQL in this article → JQL Time in status reports

But since you are on a free Jira, you will not pay for Time in Status

With our add-on, you have the power to tailor your team's work schedule, ensuring that the calculation is based solely on productive working hours.

For more in-depth data analysis, you can create reports as pivots. For example, you can look at the percentage of time spent in different statuses.

Dashboards gadgets feature will keep your finger on the pulse and track team productivity in real-time.

Add-on has 30-day free trial, free up to the 10 users and developed by my team. 

I hope you find this helpful 🚀 

[Gizem Gökçe _OBSS_]

Hello @Amelie Allen ,

Welcome to the community!

One way is to use the Jira Rest API's to pull Time in Status data from issue histories. However, building such a solution will be very time consuming for you. Every time JIRA is updated, there may be changes to the API's, the structure of the data, the structure of the issue history and so on... So you have to constantly check your code and make new adjustments. This means that you also have a maintenance (time) cost for this.

Your second option, is to use Jira Automation to do the calculation yourself and store the result into a custom field, and then view the custom field in a Jira report. Please have a look at this article. However, this method also takes time to understand and apply.

In the Atlassian ecosystem, most people use 3rd party applications, which we call plugins, to extend the capabilities of the core Jira. So in a nutshell, if you are in the Atlassian ecosystem, I suggest you get used to using plug-ins to solve your problems. Plug-ins will save you time and additional maintenance costs.

Therefore, for your needs, your 3rd and best option is to use a plug-in. For this, I can recommend Timepiece - Time in Status for Jira ,the oldest and leading "Time in Status" app in Atlassian Marketplace which is developed by my team at OBSS.  Our app is available for both Jira Cloud, and Data Center. As far as I can see, you are on the free product plan. Our app is also free for up to 10 users. So you don't have to make any additional payments to use our app. 

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

[Hannes Obweger - JXL for Jira]

Hi @Amelie Allen

welcome to the community!

As you've certainly noticed by now, this is an area that isn't well supported by Jira natively, which is why a number of Marketplace apps operate in this space. Just be aware that you can trial any for free for up to 1 month - so if an app should become an option for you, perhaps try a few and see which one works best for you.

To provide another concrete recommendation, I think you might like the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called history columns that aren’t natively available, including time in [status], time between [status] and [status], and many more. This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Amay Purohit_RVS]

Hi @Amelie Allen 

Welcome to the community !!

You can use Jira Rest API's to pull this data. Or as an alternate if your fine to try out mktplace app, take a look at

Time in Status Reports 

The app has 20+ reports to meet a variety of use cases. The standard time in status report in the screen grab below should suffice the requirement. Hope this helps.

More details here

The app is free for 10 users. Do try it out.

Disclaimer : I work for RVS, the vendor for this app

[Mehmet A _Bloompeak_]

Hi @Amelie Allen ,

Welcome to the community!

It is not possible with the built-in JQL functionalities. However, the data you need is available in issue history and you can get it using the issue REST API. Then you need coding to parse the json response and get the exact status transition date for each issue.

Another alternative is to search for free marketplace plugins.