Skip to content

Instantly share code, notes, and snippets.

trigger AccountTrigger on Account (before update){
//更新された全取引先に紐づく成立商談の金額を集計
for(Account acc:[SELECT Id,amountSum__c,
(select id,amount from Opportunities
where isWon = true)
FROM Account
WHERE Id IN :Trigger.New]){
Decimal amountSum = 0;
for(Opportunity opp:acc.Opportunities){
@cohey1975
cohey1975 / gist:5430010
Last active December 16, 2015 11:49
ApexTrigger NG pattern 01
trigger AccountTrigger on Account (before update) {
//更新された取引先に紐づく商談を取得
List<Opportunity> opportunities = [SELECT id,Amount
FROM Opportunity
WHERE AccountId=:Trigger.New[0].Id];
//Trigger.New[0]なので更新された1レコード目に関する処理のみしか実施されない。