Extract date and time when status changed

Gamesys February 13, 2018

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.

5 answers

2 votes
Pradeep February 27, 2024

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

2 votes
Valeriia_Havrylenko_SaaSJet
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 15, 2024

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

9e9e93ff-9254-4123-8774-817cc45b769d.png

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

 5f12830b-97ce-442c-ae4c-f964e527c72c.png

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

Hope it helps 😌

0 votes
Bloompeak Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 28, 2024

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.

0 votes
Shantanu Sharma January 31, 2020

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,

0 votes
Thomas Deiler
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 13, 2018

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 February 13, 2018

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 13, 2018

Dear @Gamesys,

you have to expand the history:

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

So long

Thomas

Gamesys February 13, 2018

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 13, 2018

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

Like # people like this
Thomas Deiler
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 19, 2018

Dear @Gamesys,

have you been successful with extracting your fields?

So long

Thomas

vivek karn August 30, 2018

Hi Thomas

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

Thanks in advance

Thomas Deiler
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 30, 2018

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 January 31, 2020

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,

Suggest an answer

Log in or Sign up to answer