f1lam3ntx0

reject duplicate _ bulkified code

Aug 21st, 2022 (edited)
846
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.00 KB | None | 0 0
  1. trigger RejectDuplicateFavorite on Favorite__c (before insert) {
  2.    
  3.     // NOTE: this trigger needs to be bulkified
  4.    
  5.     Favorite__c favorite = Trigger.New[0];
  6.     List<Favorite__c> dupes = [Select Id FROM Favorite__C WHERE Property__c = :favorite.Property__c AND User__c = :favorite.User__c];
  7.     if (!dupes.isEmpty()) {
  8.         favorite.addError('duplicate');
  9.     }
  10.  
  11. }
  12. ========
  13.  
  14.  
  15. Trigger RejectDuplicateFavorite on Favorite__c (before insert) {
  16.  switch on Trigger.operationType {
  17.  when BEFORE_INSERT {
  18.    RejectDuplicateFavorite.favDuplicateCheck(Trigger.new);
  19.  }
  20.  }
  21.  }
  22.  
  23.   Public with sharing RejectDuplicateFavorite{
  24.     public static void favDuplicateCheck(List<Favorite__C> FavLst){
  25.     if(FavLst != null){
  26.     for( Favorite__C : fav : FavLst){
  27.     List<Favorite__C> facQ = [SELECT id, from Favorite__C  where Property__c = :fav.Property__c and User__c =: fac.User__c ];
  28.     if(favQ.size()> 0){
  29.     favorite.addError('Favorite is already been created');
  30.     }
  31.     }
  32.     }
  33.     }
  34.   }
  35.  
Tags: Triggers
Advertisement
Add Comment
Please, Sign In to add comment