SET email_address = user_name || '@noemail.com',
lower_email_address = lower(user_name) || '@noemail.com',
updated_date = sysdate
WHERE email_address not like '%@currentdomainname.com'
In the test environment (Jira v5.2.10 + Oracle 22.214.171.124.0) we :
1. stopped Jira
2. did an direct SQL Update:
set email_address = substr(email_address, 1, instr(email_address, '@')) || 'newmaildomain.xxx'
,lower_email_address = substr(lower_email_address, 1, instr(email_address, '@')) || 'newmaildomain.xxx'
where email_address like '%@oldmaildomain.xxx';
3. started Jira
The email address is correctly shown, even in the opened issues.
What was not working in your case?
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot