+ Start a Discussion
nickwick76nickwick76 

100 record limit for external object related lists? (Lightning Connect)

Hi,
I have an external source and a couple of external objects defined and synched.
For one of the objects I have created an indirect lookup to the Account and a specified field which matches the external record with the account record. On the account page layout there is a related list with the external objects related to this account via this indirect lookup.

Now this related list seems to have a limit of 100 records.
It is possible to query the external objects via SOQL from the developer console for example and although the external records are way more than hundred there always seems to be a limit of 100 for how much that is allowed to display via the related list. 

Anyone know if this is a limit we have to live with or if there is anyway to adjust it?. For us this is very important and not really usuable else.

Thanks / Niklas
pconpcon
The limit for the maximum number of rows displayed in the related list is 100 [1] and you cannot exceed this.  You can however write a custom visualforce component and include it in your page.  Then have this custom component do your SOQL query and return all the expected results.

[1] https://help.salesforce.com/apex/HTViewSolution?id=000025257&language=en_US (https://help.salesforce.com/apex/HTViewSolution?id=000025257&language=en_US)
nickwick76nickwick76
Hi pcon and thanks for the answer.
I saw that page too before but it doesn't say that the limit I am wondering about is for external objects. It says that the maximum number you can define with https://naX.salesforce.com/xxxxxxxxxxxxxxx?rowsperlist=50 is 100.

For example, if I look at the contact related list for an account. If there are more than 100 contacts I can click 'Next' over and over again to see all of the contacts. But if I do the same for an external objects list it stops when you have reached 100 records.

There a pages about limitations for external objects but I can't see any information about this.

Maybe I should mention that I am testing this in a sandbox as well.

// Niklas