-
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
Salesforce Winter '22 Release Sandbox Preview Important Dates
Salesforce releases 3 important updates every year to stay updated with the new trends in the industry. The Winter ’22 release notes are live and…
When you Need to Switch to Salesforce Einstein Analytics
Salesforce Einstein Analytics is the cloud-based totally analytical tool that allows Salesforce customers to understand, combine, and visualize data coming from different places, which include…
All You Need to Know About Recursive Triggers in Salesforce
What are Recursive Triggers? In Salesforce, a Recursive Trigger refers to a situation where a trigger on an object causes another trigger to fire on…
Popular Salesforce Videos
COVID-19 Impact on The Automotive Industry -Digitization With Salesforce Can be a Solution
Coronavirus is expected to create a physical contactless environment with an increased thrust on online assessment and buying of vehicles. This is a huge shift…
Use Salesforce CMS to Manage and Publish Content for Experience Cloud Sites
Learn how Salesforce CMS helps you create, manage, and publish your content in Experience Cloud. With Salesforce CMS, you can also customize content for specific…
Salesforce Trailblazer Answers Leaders on YouTube
At Salesforce we’re using the power of our Trailblazer Community with Slack Connect to scale self-help content creation. Watch this short video to learn how…