-
How we get List of sibling Contact in a Salesforce Trigger?
I want a trigger on contact which prevent delete if there 3 more contact in same Account, please Write Trigger for it.
-
This discussion was modified 8 years, 9 months ago by
Shubham.
-
This discussion was modified 8 years, 9 months ago by Forcetalks.
-
This discussion was modified 8 years, 9 months ago by Forcetalks.
-
This discussion was modified 8 years, 9 months ago by
-
2 Replies
-
Hi Shubham,
You can refer this code for getting all the siblings of any contact.
Set<id> accid = new Set<id>();
for(Contact c : Trigger.old){
accid.add(c.AccountId);
}
List<contact> con = [select id, accountid, Start_Date__c, End_Date__c from contact where Account.Id in : accid AND Id not IN : Trigger.old];Map<id,List<Contact>> mapAccIdCont = new Map<id,List<Contact>>();
for(Contact c :con){
if(mapAccIdCont.containsKey(c.Accountid)){
List<Contact> conList = mapAccIdCont.get(c.AccountId);
conList.add(c);
mapAccIdCont.put(c.AccountId, conList);}
else{
List<Contact> conList = new List<Contact>();
conList.add(c);
mapAccIdCont.put(c.AccountId, conList);}
} - [adinserter block='9']
-
Trigger AreaCode on Contact (before insert) {
Set <String> InitialContact Name = new Set <String> ();
for(Contact Contact NameLoop : trigger.New)
{
if(ContactNameLoop.Area_Code__c != null){
InitialContactName.add(ContactNameLoop.Area_Code__c);
}}
Map <String, Area_Code__c> matchingAreaCodeMap = new Map <String, Area_Code__c> ();
for (Area_Code__c Record : [Select Id, Name, Market__c From Area_Code__c Where Name IN :InitialContactName])
{
matchingAreaCodeMap.put(Record.name, record);
}for(Contact ContactNameLoop : trigger.New)
{ContactNameLoop.Contact_Market__c = matchingAreaCodeMap.get(ContactNameLoop.Area_Code__c).Market__c;
}
}
Thanks
Log In to reply.
