How to query the history status of a story when the sprint completed?

[Vivian]

I'd like to get the historical  status of a story when the sprint completed which is same as the sprint report show. Because the status in sprint report show the last status when the sprint complete, but when I query by sql, the status will show the current status. 

[Zoryana Bohutska _SaaSJet_]

Hi @Vivian,

I'd like to propose the solution - the add-on Issue History for Jira Cloud (link).

It shows the history of all changes that had been made with specific issues.

Plug-in allows:
- Get the changes log ordered by the date.
- Use filters to select issues list.
- Set columns to show different fields on the report grid.
- Apply custom date range to filter results.

At the Atlassian Marketplace you can get more information about the add-on and try the trial version of it.

If you have any question, please contact me directly zoryana@saasjet.com.

[Gabriel Senna]

Hi Vivian,

If you access the issue, there is an tab in the page, called "History", where you can visualize the history and status that the issue transitioned.

In the below documentation, there are more information, regarding to this field.

https://confluence.atlassian.com/jira064/viewing-an-issue-s-change-history-720416460.html