Apex Code Development You need to sign in to do that
Don't have an account?
Learning Learning Salesforce Pageblocktable having more than 1000 records with pagination, Client side sorting , search
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
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
Use @readonly annotation in your code, You can fetch upto 10k records.
Refer the below link for more information.
http://www.salesforce.com/us/developer/docs/pages/Content/pages_controller_readonly_context_pagelevel.htm
The readOnly attribute also increases the maximum number of items in a collection that can be iterated over using components such as<apex:dataTable>, <apex:dataList>, and <apex:repeat>. This limit increased from 1,000 items to 10,000. Here is a simple controller and page demonstrating this:
Refer below link for more information.
http://www.salesforce.com/us/developer/docs/pages/Content/pages_controller_readonly_context_pagelevel.htm
Mark it for help others!!
Thanks :)
Thanks for your answers but we I cannot use readOnly attribute, since it doesnot allow to do DML operations.
And our projects involves so many dml operations.