Report on the changes date in JIRA

Question

Hi,

My JIRA tickets currently do not have Resolved Date field, but have created ,due & updated dates. So i am trying to filter when a JIRA was created & when the status of workflow was changed to DONE.  
When i look at a ticket, the changes say changed to DONE & I want to use this date to get in exported excel, how can i use it in a filter or query please?  Thanks

----sample ticket-----------

made changes - 05/Feb/24 7:16 PMStatusOriginal: Verifying [ 10036 ]New: DONE [ 10067 ]

Yuliia_Borivets__SaaSJet_ · Answer

@Sahil

With JQL, you can get all issues using status changed to Done.

Jira tickets have that info in the history section, but there is no built-in option to export issue history. So, check out these workarounds:

Solution 1. You can try to extract status history with REST API. Here is an extract from a thread I linked below:

jira = JIRA(options, basic_auth=(USERNAME, PASSWORD))

issue = jira.issue('FOO-100', expand='changelog')
changelog = issue.changelog

for history in changelog.histories:
    for item in history.items:
        if item.field == 'status':
            print 'Date:' + history.created + ' From:' + item.fromString + ' To:' + item.toString

Gives me:

Date:2012-10-23T09:49:41.197+0100 From:Open To:Queued
Date:2012-10-23T09:49:43.838+0100 From:Queued To:In Progress
Date:2012-10-23T09:49:45.390+0100 From:In Progress To:Blocked
Date:2012-10-29T16:06:36.733+0000 From:Blocked To:In Progress
Date:2012-10-31T16:47:40.191+0000 From:In Progress To:Peer Review
Date:2012-10-31T16:47:41.783+0000 From:Peer Review To:Customer Approval

Read more here:

https://community.atlassian.com/t5/Jira-questions/Is-it-possible-to-get-the-issue-history-using-the-REST-API/qaq-p/510094

Solution 2. Search for apps on the marketplace. For example, my team developed Issue History for Jira, which allows you to export history for a single or multiple issues.

An example:

Fabio Racobaldo _Catworkx_ · Answer

Hi @Sahil and welcome,

JIRA has Resolution date that will be populated when resolution field is set. My suggestion is to add resolution field in all transition screen that move your ticket in done or add a post function that populates automatically that field.

Hope this helps,

Fabio