function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
samita das 7samita das 7 

collection size exceeds

Hi All,

Problem :
I am trying to diaplay all the opportunity records in vf page. The records are more than 10000. 
Also I have set readOnly=true on vf page. The collection size increased from 1000 to 10000 but still I am not able to display.

What I did :
I queried the opportunity records and stored in a list and used datatable to populate that list on vf page.
I also tried using StandardSetController and used pagination . But then I faced issue of "
Too many query locator rows: 10003 " .I know its the limitation.

Please help me to achieve this scenario.Any workaround for this ???
 
Akshay_DhimanAkshay_Dhiman
Hi samita das 7,
 
 
 Follow these link this is helpful for you.
     1)-https://salesforce.stackexchange.com/questions/139613/content-cannot-be-displayed-too-many-query-locator-rows-10001
     2) -https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_pages_standardsetcontroller
     3)-https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_controller_readonly_context_pagelevel.htm
     
     
     Thanks 
     Akhsay
Naval Sharma4Naval Sharma4
Are you using the Database.getQueryLocator? If yes then you can only query 10,000 results. Also, make sure you are using the getCompleteResult() method to get the results.
samita das 7samita das 7
Hi Naval,

Yes. Any other ways how to achieve this screnario?
Naval Sharma4Naval Sharma4
You can do a SOQL without using the Database.queryLocator.

just do something like below.
[SELECT Id, Name FROM Account] 

But you will have to use pagination on the client side and you will have to avoid using apex:dataTable or apex:repeat. 

Client Side pagination  (https://force201.wordpress.com/2014/03/15/connecting-datatables-to-json-generated-by-apex/)

https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_controller_readonly_context_pagelevel.htm