Maximum SOQL offset allowed for apiName Property__c is 2000 - PropertyController

[denis-chiong-hexagon]

Summary

If we have more than 2000 properties in the system the navigator will fail because we cannot have an OFFSET greater than 2000

Considerations When Using OFFSET

• The maximum offset is 2,000 rows. Requesting an offset greater than 2,000 results in an error.

Salesforce Org Type

Developer Edition Org

Steps To Reproduce

1. Create over 2,000 properties.
2. Open the Property Explorer page.
3. Attempt to navigate to the last page or to a page where more than 2,000 properties need to be skipped.
4. An error appears at this point.

Current Behavior

Error retrieving data
Show details
Maximum SOQL offset allowed for apiName Property__c is 2000

Expected Behavior

Load all properties, even if the total exceeds 2,000.

Relevant Log Output

Error retrieving data
Show details
Maximum SOQL offset allowed for apiName Property__c is 2000

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Thank you for posting this issue. 🙇🏼‍♂️
We will come back to you shortly.

[pozil]

Hi @denis-chiong-hexagon, thanks for reporting the issue. I have implemented a fix.