Currently, if I export a query result to Excel and include the Assignee column, the names show up as "Bob Henderson", "Carol Zheng", etc. Is there a way to get "email@example.com", "firstname.lastname@example.org" to be exported instead?
Do you have access to the database? If you do, you can generate the query directly there and export the email addresses in a CSV. For instance:
copy (SELECT u.user_name, u.display_name, u.email_address FROM cwd_user u ORDER BY user_name) to '/tmp/users.csv' csv header;
This query will export the usernames, full names and email for every user in your instance.
Hope this helps.
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG