I have got this question several times from emails, to tweets and from lots of comments in blogs that "How can show more than 1000 records in table show that I can do more with PBE". PBE does add a lot of client side features like sorting, export, pagination etc but totally rely on data on the page to make it work, it cannot bring data from controller. So we need to bring as much as data we can to the page but to do this we need to overcome the 1K limit of list on VF.
If you haven't read about PBE (Pageblock table enhancer) you can read it here
So how can we overcome the 1K limit of list in VF pages ?
There are basically two ways- JSRemoting : Use remoting and templating library like JSRender to create a table and initialize PBE on the same. I did a small blog on something very similar where you can display records using Remote objects, but for this we need to replace the data source from remoteobjects to remoting because 100records query limit
- Using List<List<T>> : This is complete VF approach where we try to replicate the structure of pageblock table using apex:repeats.
JS Remoting
Pros
- Very fast and lightweight
- Can bring upto 15mb data
- No overhead of viewstate
- Ideal for showing long list of data
There is no better way to explain then jumping into the code.
How it works ?
- The page loads and brings data using Remoting method "getContacts"
- Once data is available the data is converted into HTML using JSrender and HTML template that is defined
- After load we call the initPageBlockTableEnhancerADV method to init PageblockEnahncer which reinitializes the PBE
Screenshot
Where we can found the component
ReplyDeleteHi Thanks For code
ReplyDeleteI have a Question I am add the code block in my code then error coming that showing render is not a function can you please correct me where i am going wrong. because that code is running fine but when I try to add in my code block that error coming
thanks in advance
vikas