Mehmet A _Bloompeak_ Atlassian Partner

Hi @Francel , You can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue…

Hi @Jeff Davis , As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In…

Hi @Elif Demirpolat , This is because your app license is not active any more. Please contact your Jira administrator for activation. They can check the license status over https://gwt-platform.atlassian.net/plugins/servlet/upm For your further questions you can reach us through https://bloompeak.io/st/support or…

Hi @Pranita Warik , Apart from changegroupitem DB table, you can get the data using below rest api. https://docs.atlassian.com/software/jira/docs/api/REST/8.15.0/#api/2/issue-getIssue Or you can search for a marketplace apps which extract the data for you. One of them is Status Time app developed by our team. It provides…

Hi @Rubèn C_ , I do not know why SLA rest api does not list all transition but I can suggest another api to get all transitions. It is the get issue api with query parameter expand=changelog. https://docs.atlassian.com/software/jira/docs/api/REST/8.15.0/#api/2/issue-getIssue

Hi @Shubham v , As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to process…

Hi @JD Lobue , As an alternative you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to process…

Hi @Angie , You can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to process the exported data. Once…

Hi @David_Tierney , Apart from manually entering worklog, you can extract time spent on each issue by calculating the time passed on each status. If this approach helps you, you can consider Status Time app. It provides reports on how much time passed in each status as well as status entry dates and status transition…

Hi @Mukama , As an alternative, you can try Status Time Free app. It displays status duration for you in issue detail page as below.

Hi @Kirill Gutmann , As an alternative, you can try Status Time app developed by our team. It provides reports on how much time spent in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to…

Hi @Aya AlJboor , As an alternative, you can try Status Time app developed by our team. It provides reports on how much time spent in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to process…

Hi @Jovanka Sejic , As an alternative, you can use Status Time add-on. It provides reports on how much time spent in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to process the exported…

Hi @Daniel Egan , As an alternative, you can use Status Time add-on. It generates status time reports based on your working calendar. If you are looking for a free solution, you can try Status Time Free.

Hi @Shailja Ginoria , In the free version, reporting (list view for multiple issues) is available but it is limited to 10 issues. For the full list, you need Status Time app. I can have a session and can explain the usage of the app details in a live demo. Please contact us over support@bloompeak.io.

Hi @taylor.roberts , There is no such report available inside Jira by default. You can use Jira REST api to get the raw data, parse the json data and calculate one by one for each issue. You need to make development for the above steps. Or you can search for a marketplace app which does all the above for you. At Bloompeak,…

Hi @Teh Kok How , We built Status Time app for this exact need. It provides reports on how much time spent in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to process the exported data. Once…

Hi @soumya wadhwa , We built Status Time app for this exact need. It provides reports on how much time spent in each status as well as status entry dates and status transition count. Report can be exported as CSV, so that you can use external tools like Microsoft Excel or Google Spreadsheet to process the exported data.…

@Lydia M, updatedDate <-5w returns all updates including status changes. But you are specifically looking for status transition update. So below can work. Project = ABC and status = Done AND status changed TO "Done" during (-5w, now())

Hi @Roberto Carrera , The raw data you need is available in history of each issue. You can get issue history data using Jira Rest Api for each issue, you get a response similar to the below. Then using coding, you need to parse json, extract the data you need for each issue. Or, you can try marketplace apps. We built…

Hi @somnath.yadav , Answer from John is the exact solution. On the other hand, if you need more info related to ticket statuses and transitions, you can check Status Time app developed by our team. It provides reports on how much time spent in each status as well as status entry dates and status transition count. Once you…

Hi @Arunn Subbaraman Thyagarajan , welcome to the community! Unfortunately, it is not possible with JQL out-of-the-box. But the raw data is available in history of each issue. You can get issue history data using Jira Rest Api for each issue, you get a response similar to the below. Then using coding, you need to parse…

Hi @Will McNelis , As an alternative, you can try Status Time app developed by our team. There is also free but limited version of it, Status Time free. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and…

Hi @Sérgio Hilgert Junior , I suggest that you use the REST API to get the issue history and via coding parse the coming json response to extract the data you need for each issue. Alternatively, you can try marketplace apps which does the above for your. We developed Status Time app for this exact need. There is also free…

Hi @Beverly Braham-Durica , We developed Status Time app for this exact need. By default it provides time spent on each status but it provides report for time spent on each assignee as well. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "Assingee time to X…

Hi @Jozef Vodny , The alternative way of accessing data on Jira cloud is the Jira Rest APIs. You can either pull the whole issue data via rest api in a scheduled manner(e.g daily) or you can define Jira webhooks which will push issue changes into your system. Alternatively, you can search for reporting apps in the…

Hi @Csiszer Csongor , It is not a built-in functionality inside Jira. You need to calculate yourself for each issue after getting the issue data over Jira rest api or you need a plugin to do the same for you. We developed Status Time app which provides various reports and one of them is average status time per assignee.…

The same rest api provides all the issue fields you need. If my fist answer above helped you, could you please mark it as "accepted answer"?

One of the below cases might be the reason. * Try passing the issue key similar to "issue/PBI-3" not just "issue/3" * Check if you have a context path after your domain while you are using jira from browser. e.g https://mydomailn.com/jira. If so, be sure that you are using the same context path in your postman url too. *…

Hi @Michal Krajnak , If you are looking for a free solution you can try Status Time Free app.