Count queries showing warning for when there is more than 10000 records.
Issue #1709
resolved
When you execute a count query from the tool editor and it’s underlying query is returning > 10000 records you get the prompt warning:
The SOQL query would return 10022 rows which is more than the configured maximum result set size of 5000.
This can result in slow query result transfer and processing times. Would you still like to execute it?
which is incorrect.
Comments (4)
-
repo owner -
reporter No but the result of a select count (Id) from account is 1 record not the 10000+ that it is warning about. (assuming that there is more than 10000 accounts in the org)
-
repo owner Ah, I see. The actual query that you're wanting to execute is itself a
COUNT
query. Makes sense. I'll fix that corner case. -
repo owner - changed status to resolved
Delivered in 2.1.4.0.
- Log in to comment
Hi, Justin. That threshold is configurable and defaults to 5000. Have you modified the value to be 10000 and it's still showing 5000?