I have create trigger and its handler class to count child records for particular parent.
Trigger countRecord on contact (after insert) { if(Trigger.isInsert){ contr.afterinsert(Trigger.new); }
}
I think the issue is with your handler class: if there are no Subject Visits left when you delete then you need to query the parent Site record not the child records. One approach I've seen is to query the parent records with a subquery of the child records and setting the parent record to the size of the child list.
this is handler class
public class SubjectTriggerHandler {
public static void perform(Set<Id> Ids){
List<CTMS__Clinical_Site__c> CSToUpdate = new List<CTMS__Clinical_Site__c>([SELECT Id, Subject_Visit_Count__c, (SELECT Id FROM CTMS__Subject_Visits__r) FROM CTMS__Clinical_Site__c WHERE Id IN :Ids]);
for (CTMS__Clinical_Site__c site : CSToUpdate){
site.Subject_Visit_Count__c = site.CTMS__Subject_Visits__r.size();
}
update CSToUpdate;
}
}
-
@VipinIndora not tested but thinking something like what I added should work depending on the child relationship name. – Jenny B Mar 16 '16 at 17:35
-
@VipinIndora what is the child relationship name for that relationship? Click on the lookup field in setup to find it. – Jenny B Mar 16 '16 at 18:14
-
@VipinIndora ok looks like I had an extra s - try it with CTMS__Subject_Visits__r vs CTMS__Subjects_Visits__r – Jenny B Mar 16 '16 at 18:20
idsthat won't be used by the handler – cropredy Mar 16 '16 at 17:14