議事録

Select By Foreign Key

2010-01-31T09:11:00.001+09:00

shop.Name =

[Select Shopping__r.name From Goods__c where Name=:goods.Name]

.Shopping__r.name;

批処理更新

2010-01-31T08:32:00.004+09:00

public void massUpdate() {

for (List <Contact> contacts:[Select FirstName, LastName From Contact]) {

for(Contact c : contacts) {

if (c.FirstName == 'Barbara' &&c.LastName == 'Gordon') {c.LastName = 'Wayne';}

}

update contacts;

}

SOQL Functions

2010-01-31T07:56:00.009+09:00

●AVG()

SELECT CampaignId, AVG(Amount)

FROM Opportunity

GROUP BY CampaignId

●COUNT()

SELECT COUNT() FROM Account WHERE Name LIKE 'a%'

●COUNT_DISTINCT()

SELECT COUNT_DISTINCT(Company)

FROM Lead

●MIN()

SELECT MIN(CreatedDate), FirstName, LastName

FROM Contact

GROUP BY FirstName, LastName

●MAX()

SELECT Name, MAX(BudgetedCost)

FROM Campaign

GROUP BY Name

●SUM()

SELECT SUM(Amount)

FROM Opportunity

WHERE IsClosed = false AND Probability > 60

SOQL Select from 2 table

2010-01-30T16:02:00.004+09:00

① select s.Name,(Select Name From Goods__r) from Shopping__c s

②Select g.Name, Shopping__r.name From Goods__c g

Create a Test Class

2010-01-30T11:26:00.001+09:00

@isTest

private class HelloWorldTestClass {

static testMethod void validateHelloWorld() {

Account a = new Account(name='T1 Account');

insert a;

a = [SELECT hello__c FROM account WHERE Id =:a.id];

System.assertEquals('World', a.hello__c);

}

Create Trigger

2010-01-30T11:06:00.001+09:00

trigger helloWorldAccountTrigger on Account (before insert) {

Account[] accs = Trigger.new;

MyHelloWorld.addHelloWorld(accs);

}

Force.com議事録

2010-01-30T11:03:00.002+09:00

今日から、Salesforce.comの研修議事録始まります。