Pagination using <rich:datascroller> but not all records fetched at a time.

[ambrish_kumar]

Hi Everyone,

I want to implement pagination using rich:datascroller. Everything works fine with datascroller but datascroller requires all data to be available.

Now my requirement is that when I click on page 2 then a query fired and fetched records from 16 to 30 for a page size of 15. When click on 3 then from 31 to 45....,on 4 from 46 to 60 and son on.

I don't want to upload all the data in the list using query.

Is it possible in <rich:datascroller> ?

Thanks

Ambrish

[bungrudi]

Hi Ambrish,

It's very possible. rich:datascroller works with DataModel implementation. So basically you just have to implement DataModel that does database paging.
There's an easy way to do this. Database paging functionality is provided in EntityQuery class. This class is extended as XxxHome when you run seam generate-entities. So you can just implement a DataModel that delegates all function call to underlying EntityQuery.
I'll post our code when we have time for this.

Rgds,
Rudi

[ambrish_kumar]

Hi Rudi,

Thanks for the reply.

Actually, We have implemented the pagination functionality without using <rich:datascroller> and it is working fine. We are not using EntityHome and EntityQuery for CRUD functionality. It will be helpful if you provide me some code explanations.

Regards

Ambrish