Is it possible to Export a list of ticket with Last modified date and last modified by ?

Question

Ivan Manolov _Appfire_ · Answer

Hello @Thierry Dubau,

The Automation route from @Mohamed BENZIANE works, with two catches. A stamped user field only fills in for changes made after the rule goes live, so older work items stay blank. Also, the Work item updated trigger skips transitions, assignments, link changes and logged work, so you'd need extra rules to catch those.

If you're open to an app from the Atlassian Marketplace, JXL for Jira can help with this. Specifically, its Last updated by user column reads each work item's change history, so existing work items are covered too:

* Create a sheet from your filter or JQL.
* Add the Updated and Last updated by user columns.
* Open More (top right), choose Export, and pick XLSX, CSV or TSV.

Disclosure: I work for the team that builds JXL.

Hope that helps,

Ivan

Mohamed Benziane · Answer

Hi,

If you'e trying to export via csv you can only have the last updated date, there is no way to get the last modified by.

If you need to get the last updated by you can use automation to update a field with the name of the user you updated and use this field in your export.

Nikola Perisic · Answer

Welcome @Thierry Dubau

* This would be much easier with Rovo since it can give you the accurate answer. 
* Another option is with this Python script

import base64
import json
import urllib.request
import urllib.error
import os
import ssl

# 1. Configuration
JIRA_SERVER = ""  # No trailing slash
JIRA_EMAIL = ""
JIRA_API_TOKEN = ""             # Replace with your actual API token

ISSUE_KEY = "MSD-13"                         # Replace with your issue key
# -------------------------------------------------------------

def get_issue_modification_details(issue_key: str):
    url = f"{JIRA_SERVER}/rest/api/3/issue/{issue_key}?expand=changelog&fields=updated,reporter"

auth_str = f"{JIRA_EMAIL}:{JIRA_API_TOKEN}"
    b64_auth = base64.b64encode(auth_str.encode("utf-8")).decode("utf-8")

headers = {
        "Authorization": f"Basic {b64_auth}",
        "Accept": "application/json"
    }

# Disable SSL certificate verification
    ssl_context = ssl._create_unverified_context()

req = urllib.request.Request(url, headers=headers, method="GET")

try:
        # Pass context=ssl_context to urlopen
        with urllib.request.urlopen(req, context=ssl_context) as response:
            data = json.loads(response.read().decode("utf-8"))

updated_date = data["fields"].get("updated", "Unknown")

last_modified_by = "Unknown"
            changelog_histories = data.get("changelog", {}).get("histories", [])

if changelog_histories:
                latest_history = changelog_histories[-1]
                author_info = latest_history.get("author", {})
                last_modified_by = author_info.get("displayName", "Unknown")
            else:
                reporter = data["fields"].get("reporter")
                if reporter:
                    last_modified_by = reporter.get("displayName", "Unknown")

print(f"Issue Key:          {issue_key}")
            print(f"Last Modified Date: {updated_date}")
            print(f"Last Modified By:   {last_modified_by}")

except urllib.error.HTTPError as e:
        print(f"HTTP Error {e.code}: {e.reason}")
    except urllib.error.URLError as e:
        print(f"URL Error: {e.reason}")

if __name__ == "__main__":
    get_issue_modification_details(ISSUE_KEY)