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.

[Pradeep]

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

[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 😌

[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.

[Shantanu Sharma]

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,

[Thomas Deiler]

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]

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",

[Thomas Deiler]

Dear @Gamesys,

I just performed a

https://server.de/rest/api/2/search?jql=project=TST&expand=changelog

and got some issues back:

The history can be found in:

issues>expand>changelog>histories>items

There you have to look for an entry with status change. Then you can take the date of the history.

So long

Thomas

[Thomas Deiler]

Dear @Gamesys,

have you been successful with extracting your fields?

So long

Thomas

[vivek karn]

Hi Thomas

Do we have any links/material to understand REST Api's in jira ?

Thanks in advance

[Thomas Deiler]

Dear @vivek karn,

for the details you get in the JSON response, it's best to explore them on your own with a Rest explorer/client. Not all possible combinations can be found in the documentation. The variations are to huge. But after you have seen some JSONs you will get familiar with the format.

So long

Thomas

[Shantanu Sharma]

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,