+ Start a Discussion
bennybutlerbennybutler 

easiest way to run a SOQL statement

I'm pretty new to the SF API, but I do have most of the development tools installed, API access via PHP on my server, the force.com eclipse thing, apex expolorer, workbench, excel data connector, etc...

 

I need to run this query (in SQL) once now to update current records, and then I can put a little more effort into having it run  nightly:

 

 

Update Lead set matchfield = concat(Email, Affiliate_Of__c)  where matchfield is null        

 

Ideas?  Will that SQL run or do I need to change it?

 

 

I've done a few things with the API, and DO know the long way would be to pull every record and then update them (individually or batch)  But I can't help but to believe there must be a simpler way to run that update.

 

Thanks

 

 

 

kbromerkbromer

Login to your account, open up the 'System Log' in the top right-hand corner. Put this code in:

 

list<lead> updateList = new list<lead>();
for (lead l : [select email, affiliate_of__c, matchfield from lead where matchfield = null])
{
l.matchfield = l.email + l.affiliate_of__c;
updateList.add(l);
}
update updateList;