function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
THustonTHuston 

Workaround for no QueryMore for v18 Aggregate SOQL

Has anyone come up with a logical way to take an aggregate SOQL like SELECT Name, MAX(Amount), MIN(Amount) FROM Opportunity GROUP BY Name and get 2001-4000... names?

 

Seems like I'd have to parse the text for the Group By * and add an Order By * to each query() and for the next batch add a Where * > [value from last row read]

However, SOQL Query text parsing is incredibly difficult and gauranteed to fail after upgrade (like the huge changes from v17 to v18).  So I need a real solution to return all the data.