I have implemented client side pagination using jQuery datatable for pagination and got this issue: Collection size 1,378 exceeds maximum size of 1,000.
This resultant list of records is from a webservice response. So, the response is giving me more than 1000 records in the list. Its all real-time query of SAP webservice. There is no SOQL and is only custom class list. I have used pageblocktable.
Experts advice please.
Best Answer
If you choose to use the
<apex:pageBlockTable />
to render your table you are normally limited to 1000 items in the collection that it iterates over.If you set the
readOnly
attribute on the<apex:page
tag with atrue
value - this limit is increased to 10,000 records in the collection.If you have more than 10,000 records in your webservice response collection, you will need to do this client-side with an ajax request and then populate the page with a table on your own, not using a
pageBlockTable
tag.Salesforce Documentation - apex:page tag