You need to sign in to do that
Don't have an account?
Ron Wild
I'm getting the error 'Too Many Query Rows: 1001' when I make the call:
Integer value = [SELECT count() from Contact where .....];
And the debug log confirms that even though count() is an aggregate function, the Apex governor counts every row matching your select criteria.
Apparently from inside a trigger the limit is 1000 and from a webservice call 10000.
Is there any way the count() function can be measured as a single SOQL row for governance purposes? It seems like it's just a toy function otherwise.
Too Many Query Rows with Count()
I'm getting the error 'Too Many Query Rows: 1001' when I make the call:
Integer value = [SELECT count() from Contact where .....];
And the debug log confirms that even though count() is an aggregate function, the Apex governor counts every row matching your select criteria.
Apparently from inside a trigger the limit is 1000 and from a webservice call 10000.
Is there any way the count() function can be measured as a single SOQL row for governance purposes? It seems like it's just a toy function otherwise.
Also, you would need a sum() function to give you the actual count of contacts rolled up to the Account records ... and the SOQL command set doesn't include that function yet.
Regards,