Tuesday, May 31, 2011

Help: Delete A Lot of Leads

Marketing: Please delete all leads with status of "Archive"

Yes, we could this 200 records a time using the Salesfoce mass delete tool. Yuch!
Or, we could do it in one line of SQLForce.

DELETE FROM Lead WHERE status='Archive';

Two seconds of work, 20 seconds waiting for Salesforce, and the 6000 records are history.