Advertisement
Guest User

Untitled

a guest
Mar 25th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. // Get Brewer Phone Numbers
  2. String brewfestName = 'Brewfest 2017';
  3. List<Brew__c> brewers = [select Id, Name, Brewer_Phone__c
  4. from Brew__c
  5. where Brewfest__r.Name = :brewfestName
  6. and Brewer_Phone__c != null];
  7. System.debug( 'Number of brewers is ' + brewers.size());
  8.  
  9. // Get the unique phone numbers
  10. Set<String> brewerPhones = new Set<String>();
  11. for ( Brew__c brew : brewers) {
  12. brewerPhones.add( brew.Brewer_Phone__c);
  13. }
  14. System.debug( 'Number of unique brewer phones is ' + brewerPhones.size());
  15.  
  16. // Get Votes by the Brewers
  17. List<Vote__c> brewerVotes = [select Id
  18. from Vote__c
  19. where Brew__r.Brewfest__r.Name = :brewfestName
  20. and Voting_Phone__c in :brewerPhones];
  21. System.debug( 'Number of brewer votes is ' + brewerVotes.size());
  22.  
  23. // Set the Brewer Vote field on Vote
  24. for ( Vote__c brewVote : brewerVotes) {
  25. brewVote.Brewer_Vote__c = true;
  26. }
  27. update brewerVotes;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement