Continuous Scrolling in ADF Tables

Paco van der Linden

One of the more promising patterns in Web UI development is Continuous Scrolling. Popular sites such as Twitter and Facebook use it. With Continuous Scrolling, new data is automatically retrieved as the user has scrolled to the bottom of the page.

I recently discovered that this is already a (not so well-known) feature for the af:table component in ADF 11g! And it is so very easy to implement! Simply set RowCountThreshold=”-1″ on your iterator in your bindings. Done!

Coincidentally it also helps performance, because now the table doesn’t need to know the exact number of rows that are available, it will discover new rows when the user scrolls to the bottom of the page. This means that getEstimatedRowCount() will not be called anymore. This might save you another query to the database. You should try it sometime.

Next Post

Advanced SQL to find valid periods - juggling with outer joins, running totals and analytical functions

Facebook0TwitterLinkedinAfter teaching the Advanced SQL Masterclass recently, one of the attendees confronted me with an interesting challenge for me to solve with all the tools I had been discussing all day. This challenge originates in the world of insurance and revolves around policies. Apparently (I am not much of an […]