How do we know when the ticket was closed

[Sana Aiman]

I want to get the actual time of when the ticket was marked done.Just like we have a time issue created on. I want to the time when the issue was closed (marked done).

[BHUSHAN PATIL]

Hi @Sana Aiman ,

In Jira Service Management, you can find the time an issue was resolved or closed in the issue details. When you open an issue, you should see details like status, assignee, etc. Look for a field labeled "Resolved" or "Closed." This field typically shows the date and time when the issue transitioned to a closed or resolved status.

Additionally, the issue history in Jira records all transitions and changes. If you have permission to view the issue history, you can check the timestamps of transitions to a "Done" or "Closed" status. Each transition in the issue history will have a timestamp showing when the transition occurred.

Also, if you feel my input help you please accept the answer.

Regards,
Bhushan

[Sana Aiman]

How to extract this resolved time for list of issues.

[BHUSHAN PATIL]

Could you please explain more , exactly what is your use case or what you want to extract?

[Sana Aiman]

I have a list of tickets assigned to a person and i need to know when was each ticket closed.
The exact date and time.

[BHUSHAN PATIL]

Hi @Sana Aiman ,

you can achieve this using Jira's JQL to filter the issues assigned to a specific person and marked as "Done" and then export the results to a CSV file. Here are the steps you can follow:

1. Use a JQL query to filter the issues assigned to a particular person and marked as "Done." For example:

   assignee = "username" AND status in (Done, Closed)

   Replace "username" with the actual username of the person you're interested in. Adjust the JQL query according to your specific criteria.
2. Export the Issues: Once you've applied and verified the JQL query to display the desired issues, proceed to export them to a CSV file.

• Select the fields you want to include in the exported CSV. Ensure that the "Resolved" or "Resolution Date" field is included to capture the date and time when the issue was resolved.
• After exporting, open the CSV file using a spreadsheet editor like Microsoft Excel, Google Sheets, or any other compatible tool. Look for the column that corresponds to the resolution date or the field representing the closure time for each issue.

This process allows you to filter the issues using JQL to match your criteria, export them to a CSV file, and review the resolution date and time for each issue in a tabulated format for the assigned person.

if you feel my input help you please accept the answer.

Regards,
Bhushan