8 Replies Latest reply: Dec 15, 2012 12:48 AM by _user RSS

    how to get specific rows from the vo or Iterator in the backing bean?

    _user
      Hi,

      I have to get the specific number of rows from iterator in the backing bean. means i want to get the records from the VO or Iterator only from 5 th record to 10th record its like rownum in SQL.

      We can use rownum in VO sql query. but there would be a performance issue with that ...

      SO i am trying to get the rows from ADF Iterator once we fetch from DB.

      Is it possible to do that ?

      Do we have any way to set the pointer to the VO/Iterator like setFirst() and after that setMaxResult to retrun the rows between first and maxresult..



      Thanks