Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public list<AggregateResult> getInboundMarc(){
- list<AggregateResult> inboundMarc = [SELECT Count(Id) cnt, Sold_By__r.Name rep, Policy_Carrier__c car
- FROM Case
- WHERE Status = 'Sold' AND Sold_By__c !=:outb.Sold_By_Role__c AND Sold_By_Role__c !=:insura.Sold_By_Role__c
- AND Sold_By_Date__c = THIS_MONTH
- GROUP BY Sold_By__r.Name, Policy_Carrier__c
- ORDER BY Count(Id)
- DESC];
- return inboundMarc;
- }
- <apex:page controller="SalesRecordsController" >
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement