How do we know when the ticket was closed

Question

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_fap6cn · Answer

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:

* 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.
* 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

Sana Aiman_6tf8rr · Answer

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_fap6cn · Answer

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