how to show >10000 records for pagination

Question

from StandardSetController we can show 10000 records(Limit 10000 because Database.QueryLocater fetch 10000 records) for PAGINATION , but i have 300000 contacts how can i paginate. and Offset Limit is 2000 records

Answer 1

You can either use client-side or server-side pagination. Either way, you won't be able to use standard tools like StandardSetController or OFFSET.

Server-side, you need to use the @ReadOnly annotation to enable the 1,000,000 row limit, which might look like this:

@RemoteAction @ReadOnly public static SObject[] getRecords(Integer page) {
    SObject[] results = new SObject[0];
    for(SObject[] records: [SELECT ... FROM SObject WHERE ... LIMIT :page*200]) {
        results = records;
    }
    return results;
}

From there, you just repeatedly call the value until you get all of your results:

var buffer = []
function getPage(i) {
    myController.getPage(i, function(event, data) {
         if(data.length) {
             data.forEach(function(v) {buffer.push(v)})
             getPage(i+1)
         }
    }
}

Client-side, it'd look more like this example from the docs:

var result = sforce.connection.query("select id, name from account"); 
var it = new sforce.QueryResultIterator(result); 
var buffer = [];
while (it.hasNext()) { 
    var account = it.next(); 
    buffer.push(account);
} 

In either case, once the client's loaded all the data, it's up to you to implement client-side pagination, perhaps using jQuery, AngularJS, etc.

Answer 2

You will have to query the entire 300,000 contacts in your controller and hold them in a private list of contacts. You'll want a separate list of Contacts that you will use to display on the page. For pagination you will have to write your own code that will take the appropriate amount of Contacts from the private list and add them to the pagination list.