-
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
How to Get Your Org Ready for GDPR Compliance | Salesforce Org GDPR
In a mature Salesforce Org with hundreds of thousands of records, it might be difficult to know where to start on GDPR compliance. In this post,…
Here's How Salesforce Promotes Collaboration through Interoperability
With problems like COVID-19 ransacking the world, have you ever wondered how governments had worked closely with other governments on a national and local level…
What is Constructor in Apex Programming? | Salesforce Apex Guide
In Apex programming, a Constructor is a unique code used to set up a newly created object. It is called right after the memory for…
Popular Salesforce Videos
Introduction to Journey Builder in Salesforce Marketing Cloud
Marketing Cloud's Journey Builder is a campaign planning tool that enables you to design and automate campaigns that guide customers through their journey with a…
Data Loader In Salesforce | Import or Export Data From Salesforce
How to import or export data using Data Loader in Salesforce. This video will cover the following points - 1. Introduction to Data Loader (0:16)…
Being a Sr. Salesforce Consultant | SFDC Consultant Podcast
What it is like being a Sr. Salesforce Developer at a consulting firm. What a day in Sr. Salesforce Consultant's life looks like. Struggles of…