I am facing a issue about aggregate soql. My basic data object more than 500,000 record. But, i want to aggregate this object data. When i execute following data, SFDC will report the error for me. About, need to use querymore() function. And, found that, only 200 record return to me. In fact, I just want to get aggregate result in apex list. So, how to working on large aggregate soql?
My Error SOQL: SELECT SUM(CALL_Total_abc__c),Customer_abc__c FROM HOSP_SPECIALTY_PROD_KPI_abc__c WHERE BI_UPDATE_DATE_MSD__c = 2014-09-01 group by Customer_abc__c