Can anyone please tell me if there is something wrong with the scrip below. I am using LIMIT 50000 but still getting this error. I will appreciate any help!
code:
//for mws chart
AggregateResult[] groupedSales
=[SELECT CALENDAR_MONTH(Purchase_Date__c),CALENDAR_YEAR(Purchase_Date__c), SUM(Detail_Total__c)
FROM MWSOrderItem__c
WHERE Purchase_Date__c = LAST_N_DAYS:365 AND Buyer_lookup__c =:UserInfo.getUserId()
GROUP BY CALENDAR_MONTH(Purchase_Date__c),CALENDAR_YEAR(Purchase_Date__c)
ORDER BY CALENDAR_YEAR(Purchase_Date__c),CALENDAR_MONTH(Purchase_Date__c) ASC LIMIT 50000 ];
List1 = new List<String>();
for (AggregateResult ar11 : groupedSales ) {
List1.add(String.valueof(ar11.get('expr0')+'/'+String.valueof(ar11.get('expr1'))));
List1.add(String.valueof(ar11.get('expr2')));
}