You need to sign in to do that
Don't have an account?
XIO
Merging 4 Apex Triggers into 1
I have created 4 triggers that I merged into 1 trigger for "best practice." The trigger works very well in the sandbox but I don't believe I have merged the triggers correctly. Any assistance or suggestions to help me merge these triggers correctly is greatly appreciated!
Merged trigger below.
Merged trigger below.
trigger SurveyHandling on Relationship_to_Initiative_Research__c (after insert,after delete,after update) { list<Id> rlist1=new list<Id> ();String sss=''; list<Initiatives__c > rlsit=new list<Initiatives__c >(); //////////// insert and update operation if(trigger.isinsert || trigger.isupdate){ for(Relationship_to_Initiative_Research__c i : trigger.new) { rlist1.add(i.Initiative_Title__c ); } Initiatives__c ini=[select id,Action_ItemsRICHTEXT__c from Initiatives__c where id in:rlist1]; for(Relationship_to_Initiative_Research__c rr:trigger.new){ ini.Action_ItemsRICHTEXT__c=rr.Action_Item_ScriptRICHTEXT__c ; rlsit.add(ini); } update rlsit; } /////////////// Delete operation start if(trigger.isdelete){ for(Relationship_to_Initiative_Research__c i : trigger.old) { rlist1.add(i.Initiative_Title__c ); } Initiatives__c ini=[select id,Action_ItemsRICHTEXT__c from Initiatives__c where id in:rlist1]; for(Relationship_to_Initiative_Research__c rr:trigger.old){ ini.Action_ItemsRICHTEXT__c=rr.Action_Item_ScriptRICHTEXT__c ; rlsit.add(ini); } update rlsit; } list<Id> rlist2=new list<Id> ();String ssss=''; list<Initiatives__c > rlist3=new list<Initiatives__c >(); //////////// insert and update operation if(trigger.isinsert || trigger.isupdate){ for(Relationship_to_Initiative_Research__c i : trigger.new) { rlist2.add(i.Initiative_Title__c ); } Initiatives__c iniTF=[select id,Timeframe__c from Initiatives__c where id in:rlist2]; for(Relationship_to_Initiative_Research__c rrr:trigger.new){ iniTF.Timeframe__c=rrr.Timeframe__c ; rlist3.add(iniTF); } update rlist3; } /////////////// Delete operation start if(trigger.isdelete){ for(Relationship_to_Initiative_Research__c i : trigger.old) { rlist2.add(i.Initiative_Title__c ); } Initiatives__c iniTF=[select id,Timeframe__c from Initiatives__c where id in:rlist2]; for(Relationship_to_Initiative_Research__c rrr:trigger.old){ iniTF.Timeframe__c=rrr.Timeframe__c ; rlist3.add(iniTF); } update rlist3; } list<Id> rlist4=new list<Id> ();String sssss=''; list<Initiatives__c > rlist5=new list<Initiatives__c >(); //////////// insert and update operation if(trigger.isinsert || trigger.isupdate){ for(Relationship_to_Initiative_Research__c i : trigger.new) { rlist4.add(i.Initiative_Title__c ); } Initiatives__c iniO=[select id,Owner__c,Initiative_Owner__c from Initiatives__c where id in:rlist4 Limit 1]; for(Relationship_to_Initiative_Research__c rrrr:trigger.new){ iniO.Owner__c=rrrr.Owner__c ; rlist5.add(iniO); } update rlist5; } /////////////// Delete operation start if(trigger.isdelete){ for(Relationship_to_Initiative_Research__c i : trigger.old) { rlist4.add(i.Initiative_Title__c ); } Initiatives__c iniO=[select id,Owner__c,Initiative_Owner__c from Initiatives__c where id in:rlist4]; for(Relationship_to_Initiative_Research__c rrrr:trigger.old){ iniO.Owner__c=rrrr.Owner__c ; rlist5.add(iniO); } update rlist5; } list<Id> rlist7=new list<Id> ();String ssssss=''; list<Initiatives__c > rlist8=new list<Initiatives__c >(); //////////// insert and update operation if(trigger.isinsert || trigger.isupdate){ for(Relationship_to_Initiative_Research__c i : trigger.new) { rlist7.add(i.Initiative_Title__c ); } Initiatives__c iniP=[select id,Progress__c from Initiatives__c where id in:rlist7]; for(Relationship_to_Initiative_Research__c rrrrr:trigger.new){ iniP.Progress__c=rrrrr.Progress__c ; rlist8.add(iniP); } update rlist8; } /////////////// Delete operation start if(trigger.isdelete){ for(Relationship_to_Initiative_Research__c i : trigger.old) { rlist7.add(i.Initiative_Title__c ); } Initiatives__c iniP=[select id,Progress__c from Initiatives__c where id in:rlist7]; for(Relationship_to_Initiative_Research__c rrrrr:trigger.old){ iniP.Progress__c=rrrrr.Progress__c ; rlist8.add(iniP); } update rlist8; } }