Export Reporter Email Addresses?

Jeremy Davis_uvhcah

Hello,

I am looking to create an external Customer Satisfaction Survey to send to anyone who reported an issue during the previous quarter.  I can write the JQL to select the relevant issues, but in the Reporter field all I get is their name.  I don't see any columns with their email address in them.

I believe I can copy and paste from the Customers report but that is clunky and would require matching up email addresses with names, etc.

Is there a way to export the Reporter email address directly?

Jon Karnofsky

I just discovered a good solution for this, if you use Google Sheets. From https://community.atlassian.com/t5/Jira-Service-Management/Is-there-a-way-to-export-more-than-1000-issues-in-jira/qaq-p/662507, this Google Sheets plugin is referenced:

https://gsuite.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016

When you connect and query, there's two great features:

1. You can not only select the fields, it has access to some related record fields. I was able to select Creator.emailAddress (see below). This was superb as some of my reporters are users, not just portal customers, and this reference got the emails for all of them.
2. You can also select how many records you want to retrieve. This gets past the issue export limit of 1000 records (this is how I found this post originally).