Count queries showing warning for when there is more than 10000 records.

Issue #1709 resolved
Justin Julicher created an issue

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)

  1. Scott Wells repo owner

    Hi, Justin. That threshold is configurable and defaults to 5000. Have you modified the value to be 10000 and it's still showing 5000?

  2. Justin Julicher 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)

  3. Scott Wells 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.

  4. Log in to comment