Advertisement
Guest User

Untitled

a guest
Sep 19th, 2014
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. public list<AggregateResult> getInboundMarc(){
  2. list<AggregateResult> inboundMarc = [SELECT Count(Id) cnt, Sold_By__r.Name rep, Policy_Carrier__c car
  3. FROM Case
  4. WHERE Status = 'Sold' AND Sold_By__c !=:outb.Sold_By_Role__c AND Sold_By_Role__c !=:insura.Sold_By_Role__c
  5. AND Sold_By_Date__c = THIS_MONTH
  6. GROUP BY Sold_By__r.Name, Policy_Carrier__c
  7. ORDER BY Count(Id)
  8. DESC];
  9.  
  10. return inboundMarc;
  11. }
  12.  
  13. <apex:page controller="SalesRecordsController" >
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement