SOQL extension: Retrieving more than 2000 rows

[Andrei2233]

Awesome extension by the way!

Currently, there's a limit of retrieving max 2000 rows. It would be awesome if this could be greatly increased. 🙈

[diyer]

Thanks for the suggestion @Andrei2233 ! Converting this to a discussion for our community

[mcoTLC]

I'll add to this - the solution seems like adding an "Offset" field (similar to the "Limit" field) would solve this. It would, as with the "LIMIT" function, add a line to the end of the query to "OFFSET" instead of "LIMIT" (or along with, if the user desires).

[daphne-sfdc]

Good idea - GUS WI here: https://gus.lightning.force.com/lightning/r/ADM_Work__c/a07EE00002YillWYAR/view

[daphne-sfdc]

Hi @Andrei2233, We have some good news for you! In this PR, we added a new Max Query Limit setting to allow users to change the value of the maximum number of rows they can retrieve when running SOQL queries. The new default number of rows returned has also been increased to 50000. 🙂

This feature was released in v66.11.0 of the SOQL extension. Update to the latest version of the extensions to try it out! 💃