Load more does not work correctly in a table that is tied to an external object made available via SF connect

  • 1
  • Problem
  • Updated 3 years ago
  • Not a Problem
Load more does not work correctly in a table that is tied to an external object made available via SF connect. In my case, I have an external object that has 9 records but on the model, I have set to initially load 5 records. So after page load, the table had five records displayed and shows 5+.  After clicking “load more”, I see 5 records and the record count is 5.

For this specific case, if I set the model to initially load 10, then the table has 9 records displayed with a record count of 9 and no “load more” button.

Photo of Eric Tuggle

Eric Tuggle

  • 342 Points 250 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Do you have a sort order set on on this model?  If that order is not granular enough to differentiate between records sometimes the salesforce standard controller gets confused.  Add Id as the final sort order item in your model.

Hopefully this will take care of things.  
Photo of Eric Tuggle

Eric Tuggle

  • 342 Points 250 badge 2x thumb
Thanks that worked and solved the issue