How do I get the date of the task status change and its timespent?

Question

I'm looking for a way to keep track of the time spent on Reopened tasks beyond the expected value. Im using python-jira library. As a result  I want to get the date of the status change and the amount of time that will be spent on her decision.

I've already written some code, but I haven't gotten the result.

def get_issues_from_task(username=None, token=None, project_key=None):
    jira = JIRA(basic_auth=(username, token), options={'server': SERVER})
    jql = 'project=' + project_key + ' AND status changed FROM Closed TO Reopened'
    issues_list = jira.search_issues(jql, json_result=True) #get the issues list

for i in issues_list['issues']:
        isssues_key = i['key']
        issue = jira.issue(res, expand='changelog')
        changelog = issue.changelog
        for history in changelog.histories:
            for item in history.items:
                if item.field == 'status':
                    # here I need to get the date of the status change to Reopened and the new time it takes to do it.

return data

Tell me please how I can finish this code or redo it.

Mohamed Benziane · Accepted Answer

Hello,

Take a look at the @Chris Young4 answer in this thread. It is a good point to start. You will need to create a loop and make some calculation to achieve what you want.

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

Hope this helps