UPDATE CWD_USER
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'
It is a dumb method, but worked for me.
Have you tried to dump everything to xml backup file, and then using email regex like this:
="^([0-9a-zA-Z]([-\.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$"
or simple: ="(.*?)@(.*).[a-zA-Z]{2,4}"
We were getting ready to try editing the xml backup file (find/replace all) but my co-worker said you're method was even better. We'll try it out tomorrow. Thanks - we'll let you know if it worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How about using the JIRA Command Line Interface:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In the test environment (Jira v5.2.10 + Oracle 11.2.0.3.0) we :
1. stopped Jira
2. did an direct SQL Update:
update cwd_user
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.
Question:
What was not working in your case?
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.