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?
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is awesome! Didn't even know it existed, but helps with so many use cases.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.