-
How to delete child records in lookup relation (with Salesforce triggers)
object A is child of object opportunity
I want to delete all the child records ie object A when opty stage is closed lost.
Use TRIGGERS
-
3 Replies
-
Check out this one.. Click here to get the solution DeleteChildrenFromOppty
You can optimize it further based on design patterns you use.
-
Hi,
Please find the below code:
trigger DeleteChildrenFromOppty on Opportunity (before insert, before update, after insert, after update) {
if(Trigger.isAfter && Trigger.isUpdate){
set<Id> setOpportunityIds = new set<Id>() ;
for(Opportunity opp : Trigger.new){
if((!opp.isWon && opp.isClosed) && !(!Trigger.oldMap.get(opp.Id).isWon && Trigger.oldMap.get(opp.Id).isClosed)){
setOpportunityIds.add(opp.Id) ;
}
}
if(!setOpportunityIds.isEmpty())
delete([SELECT Id from Object_A__c WHERE Opportunity__c IN: setOpportunityIds]) ;
}
}Hope this helps you.
Thanks.
-
trigger deleteuniversity on University__c (before insert,before delete,after delete) {
set<id> ids =new set<id>();
if(trigger.isbefore && trigger.isdelete)
{
for(University__c u:trigger.old)
{
ids.add(u.id);
}
system.debug('ma size'+ids);
Deleteuniversityhelper.emp =[SELECT Id, University__c FROM Employeee__c where University__c in:ids];
}
if(trigger.isafter && trigger.isdelete)
{ system.debug('ma size'+Deleteuniversityhelper.emp);
delete Deleteuniversityhelper.emp;
}}
public class Deleteuniversityhelper {
public static list<Employeee__c> emp;
}
Log In to reply.
Popular Salesforce Blogs
No Code MuleSoft Composer Integration with Salesforce
MuleSoft Composer is the first integration tool embedded in the Salesforce platform and offers a declarative interface to making integrations. It can directly integrate with…
Magento 2 Integration With Salesforce: Unleashing The Power Of eCommerce
Are you struggling to take your online store's performance to new heights? Look no further! In today's digital age, seamless integration is the key to…
Best Practices for Salesforce Lightning Web Components (LWC)
Always Name Carefully Always name variables, methods, and components carefully. Do not start a property name with ‘on’, ‘aria’, or ‘data’. Do not use reserved…
Popular Salesforce Videos
Salesforce Introduced Next Generation Of Tableau Cloud
Salesforce added a new member to its fleet of the cloud for customers: Salesforce Tableau Cloud. The Tableau Cloud developed will empower the customers to…
Running a New Report in Salesforce
After logging into Salesforce, Go to the reporting section by clicking on the Reports tab at the top of the page, Click on the New…
Rollup Trigger via Salesforce Record Triggered Flow - Trigger without code
Hello Folks, I created a Rollup trigger via Salesforce Record Triggered Flow (without code cool isn't). I use Record trigger Flow for that scenario. There…
