You need to sign in to do that
Don't have an account?
ruchika Nayyar
Write a trigger on Account when Account is update check all opportunity inside the account. Update all Opportunities Stage to close lost if an opportunity created date is greater than 30 days from today and stage not equal to close won.
how to write this code help me out?/
Write a trigger on Account when Account is update check all opportunity inside the account. Update all Opportunities Stage to close lost if an opportunity created date is greater than 30 days from today and stage not equal to close won.
Write a trigger on Account when Account is update check all opportunity inside the account. Update all Opportunities Stage to close lost if an opportunity created date is greater than 30 days from today and stage not equal to close won.
Please find below code:
Trigger Account_Trigger on Account(After Update){
List<Opportunity> OpportunityList = new List<Opportunity>();
Map<Id, Opportunity> opptyMap = new Map<Id, Opportunity>([select id, stageName, AccountId, createdDate from Opportunity where AccountId IN: trigger.newMap().keyset()]);
DateTime Opportunity30Days = system.now()-30;
for(Opportunity opp: opptyMap.values()){
if(opp.createdDate < Opportunity30Days && opp.stageName != 'close won'){
opp.stageName = 'close lost';
opp.closeDate = system.today();
OpportunityList.add(opp);
}
}
if(OpportunityList != null && OpportunityList.size() >)
insert OpportunityList;
}
Let me know if you need assistance on this.
Thanks,
Gaurav