I have a TEST instance for JIRA and need to do extensive testing to complete a request from users. However, I do not want users to receive notification from this instance.
Is there any way all email generated can be redirected to a dummy email address? I know I can disable notification by deleting mail server details or by deleting notification scheme associations from projects, but I still want to see the notifications generated.
There is a way I can think is manually update all user email address to only one email address since is for stage/test environment purpose. You may try to run the SQL statement below to update all user email address in database:
update cwd_user set email_address='<email_address>', lower_email_address='<email_address>';
Please give a try and let us know how it goes.
By the way, that is a very specific piece of advice about the database. If you are touching any part of Jira that may be cached, counted or active, then you will break your Jira by amending the database while it's running.
I don't believe the user's email addresses are cached, so this should be safe. BUT, almost everything else is NOT safe to edit while Jira is running.
In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to have–in order to produce a reliable long-term roadmap. We're tur...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs