Hi,
I have an requirement where I need to create pageBlock table which has the below fetatures
1: Table should display more than 5000 records
2: client side pagination
3: Client side sorting
4: Search for text from table records

I have implemented the following
1: using jquery I have achieved  2nd, 3rd and 4th requirements but here we cannot have more than 1000 records in table
(reference : http://force201.wordpress.com/2013/08/17/client-side-sorting-and-pagination-of-an-apexpageblocktable/ )
2: Using offSet we can fetch upto 2000 record only and client side sorting , searching options are not available
3: Usign standardSetController we can get upto 10000 reocrds with pagination, but we cannot do clientside sorting, searching

Is there any way to achieve all the 4 options metnioned above? or atleast first 3. Please help




 

Hi,
I have an requirement where I need to create pageBlock table which has the below fetatures
1: Table should display more than 5000 records
2: client side pagination
3: Client side sorting
4: Search for text from table records

I have implemented the following
1: using jquery I have achieved  2nd, 3rd and 4th requirements but here we cannot have more than 1000 records in table
(reference : http://force201.wordpress.com/2013/08/17/client-side-sorting-and-pagination-of-an-apexpageblocktable/ )
2: Using offSet we can fetch upto 2000 record only and client side sorting , searching options are not available
3: Usign standardSetController we can get upto 10000 reocrds with pagination, but we cannot do clientside sorting, searching

Is there any way to achieve all the 4 options metnioned above? or atleast first 3. Please help