Hitting SOQL Too Many Query Rows with AVERAGE

jamessimone / apex-rollup

Fast, configurable, elastically scaling custom rollup solution. Apex Invocable action, one-liner Apex trigger/CMDT-driven logic, and scheduled Apex-ready.

MIT License

222 stars 30 forks source link

Hitting SOQL Too Many Query Rows with AVERAGE #589

Closed PhilTerz closed 6 months ago

PhilTerz commented 6 months ago

Over a large dataset, AVERAGE is requerying in each batch chunk handler. I can see each handler's log does a query that fails after returning 50,001 rows.

jamessimone commented 6 months ago

Thanks for submitting this! I should be able to start working on this today or tomorrow.

jamessimone commented 6 months ago

@PhilTerz apologies, I've had less time to get the fix for this out there than I had hoped for. I have things working for AVERAGE but I expect to have more time in the next day or two to sew up a few other operations that suffer from a similar issue. You can expect this fix to be released in the next few days!