Extracting information on all tickets worked upon

Question

Hi, How can i extract all the tickets worked by a particular person?

E.g. I have 2-3 stages through which a ticket flows to Business Analyst bucket. At any instance, if i want to check how many tickets him/her have worked upon can i extract that from filter section?

Aron Gombas _Midori_ · Answer

In addition to what @Trudy P Claspill suggested, you could also export the full change history of the issues to Excel like this:

In this spreadsheet (download here) each row contains a change with the change field, old and new value, so you can filter to the changes of the "Assignee" field. Then you can use the Excel features to analyze the result, create a pivot table, for example.

In addition to the Excel flexibility, the nicety in this approach is that you can select the additional columns to export (issue key, summary, project, any other field), so you can include other fields in the report.

The sheet was created with Better Excel Exporter, a paid and supported app our team has been working on for 10+ years.

Trudy P Claspill · Answer

Hello @Mayur Gaikwad/Tech PMO

You can use the WAS operator with the Assignee field to find issues where the Assignee was set to a specific user.

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#WAS