Removing customer email addresses in non-production environment

很多事情很多心情写了也就记下了; 不写,以后可能就忘了.
打印 被阅读次数

To avoid accidently send emails to customers when we doing the testing in non-production environment, we need to remember to remove the real customer emails when we clone from production.

Here is the query to run:

update HZ_CONTACT_POINTS set email_address = '' where owner_table_id in

   (select party_sites.party_site_id from hz_party_sites party_sites, hz_cust_acct_sites a_bill

   where party_sites.party_site_id = a_bill.party_site_id )

commit;

登录后才可评论.