Advertisement
NoFrAg

Anonymize Account Emails

Jun 19th, 2018
664
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.80 KB | None | 0 0
  1. Contact[] e = [SELECT Id, Email_Additional__pc, Email_C1__pc, Email_Fb_Ca__pc,
  2.                Email_SAP__pc, PersonEmail FROM Account WHERE
  3.             (Email_Additional__pc != 'kimtestigr@gmail.com' OR
  4.              Email_C1__pc != 'kimtestigr@gmail.com' OR
  5.              Email_Fb_Ca__pc != 'kimtestigr@gmail.com' OR
  6.              Email_SAP__pc != 'kimtestigr@gmail.com') AND
  7.             (Email_Additional__pc != '' OR Email_C1__pc != '' OR
  8.              Email_Fb_Ca__pc != '' OR Email_SAP__pc != '')];
  9.     for (Contact i : e) {
  10.         i.PersonEmail = 'kimtestigr@gmail.com';
  11.         i.Email_C1__pc = 'kimtestigr@gmail.com';
  12.         i.Email_Fb_Ca__pc = 'kimtestigr@gmail.com';
  13.         i.Email_SAP__pc = 'kimtestigr@gmail.com';
  14.         i.Email_Additional__pc = 'kimtestigr@gmail.com';
  15.     }
  16. update e;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement