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?
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:
When you connect and query, there's two great features:
The solution proposed by Jon is also available for people using Microsoft Excel, using the free official Excel add-on Jira Cloud for Excel (official) | Atlassian Marketplace
Everything looks and works very similar to the post above. Thanks to all involved, great solution!
The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events