• Mike Tang
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
Hello, I am having problems with this query producing a Run Time error and I am not sure why.  Any help would be appreciated.

             List<AggregateResult> quotes = new List<AggregateResult> ();
            quotes = [ SELECT Quote.Account.Owner.Name, COUNT (id) FROM Quote WHERE Scheduled_Phone_Interview__c=THIS_MONTH  GROUP BY Quote.Account.Owner.Name ];
            
            for (AggregateResult quote:quotes){
                //Do something
            }

It compiles fine but I get a non-discript error:

SQLException in Class.CyberSn.MonthlyReport.<init>: line 24, column 1 Class.CyberSn.<init>: line 3, column 1 
Class.CyberSn.MonthlyReport.<init>: line 24, column 1
Class.CyberSn.<init>: line 3, column 1