I want to know who my most productive developers are and I need a query to determine who had what issues/bugs etc in the sprint, and how long they stayed in each part of the workflow.
You can see issues in a sprint by executing the following JQL:
sprint = Srprint1
But to get information about how long an issue was in a status, you would need an add-on.
For example, you could use this add-on:
A new way to create a Jira sprint report by user is possible with a dedicated report template by Better Excel Exporter for Jira! You can get an understanding of how workload is distributed among assignees and much more!
Follow this step-by-step guide on how to create a Jira sprint report in Excel:
(Please note that Better Excel Exporter for Jira is a paid and supported app and I'm part of the team developing it.)
If you would like to see how far you can get without add-ons... You could use the control chart and add quick filters on your board for each assignee. It probably does not answer all of your question but it will answer how much time issues remain in a certain status, averages et cetera.
@Andrew ThomasAlso, you can try app Time in status for Jira Cloud by SaaSJet . One of its reports "Assignee time" will help you. Just filter data by Assignee or Reporter and you will get information about all issue that was assigned to that employee. Besides that, you can see a time that he and other persons were spent on this issue.