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; } } }

Extract date and time when status changed

Gamesys

I would like to extract a list of date and time when tickets within a certain project changed from "open" to "in progress" which can be clearly seen in the history.

project = $projectname AND issuetype = "$issuetype" AND status changed to "$state" during ("2018-01-10","2018-01-11")

With this search, I can only see the list of tickets but I am interested to extract the data within each of the tickets.

Accepted answers

All comments

Thomas Deiler_db00h3

Dear @Gamesys,

the information you are looking for, is stored in the history only, that will not be displayed as a search result.

You could query the REST API, to extract the dates, when the transition from 'open' to 'in progress' was made.

Are you familiar with the API?

So long

Thomas

Gamesys

Yes @Thomas Deiler and currently I am using:

https://$HOST/rest/api/2/search

However it is only extracting the content within the ticket itself and not inside the history or transitions.

Thomas Deiler_db00h3

Dear @Gamesys,

you have to expand the history:

/jira/rest/api/2/search?expand=changelog

So long

Thomas

Gamesys

Thanks @Thomas Deiler. Yes I am trying to extract the information using the changelog and also tried using the expand=transitions.fields but failed to extract the fields I am interested in:

{"expand":"names,schema","startAt":0,"maxResults":50,"total":1,"issues":[{"expand":"operations,versionedRepresentations,editmeta,changelog,renderedFields",

Shantanu Sharma_34fuzt

Dear @vivek karn ,

Sorry to say, there is one way to understand jira api

you have to read jira API documentation

https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-search-get

Thanks,

Valeriia_Havrylenko_SaaSJet

Hi @Gamesys and everyone who is looking for solution 😌

As an alternative, you can try - Time in Status for Jira (Cloud, Data Center), (developed by my team) that generates 7 types of status reports including Status Entrance Date report. It shows the date a particular issue has entered each of a status (Resolved or Closed, etc.).

set date or date ranges you need
get dates when the issue has entered each of the statuses on the grid.

On the chart, it shows the number of tasks that have entered a status on a certain date - for example, 1 task out of 5 tasks has entered the Progress status for the first time on the 23-rd of May.

Add-on has a 30-day free trial version and free up to 10 users .

Hope it helps 😌

Pradeep_x5qvlb

You can use Jira API's to extract this data. Or use a mktplace app for the same.

Please try out an add-on we have developed for the same use case.

Time in Status Reports

The status transition details report shows when the issue was transitioned to which status and on which date and by whom. Also the app has 20+ reports to track your bottleneck Issues & Processes.

More details here

Disclaimer : I work for the vendor who built this app

TIS - Status Transition Details.PNG

Mehmet A _Bloompeak_

Hi @Gamesys

Jira doesn't have a built-in solution for the reports you mentioned. You can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app. To get a report of status transition dates, you can have a look at Status Count And Entry Dates report. Entry date(see In Development, Ready for Testing, In Testing, In Development columns.) is status transition date and status count(see #In Development, #Ready for Testing, #In Testing, #In Development columns) is how many times an issue is entered to this status.

App Features:

This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
Status durations are calculated according to the working calendar you define. 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 closed on Monday at 9 AM, will be a few hours rather than 3 days.
You can set different duration formats.
You can export reports in CSV file format and open them in MS Excel.
You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

For further details, you can have a look at Status Time Reports How to Videos.

If you are looking for a completely free solution, you can try the limited version Status Time Reports Free.

Hope it helps.

Welcome!

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

Quick Links

Find more posts tagged with

jira