Hello Chandra,

To iterate through a VO in OAF by either RowSetIterator and then loop through it to fetch attributes value, or using FilteredRows this will give us an advantage of getting only rows that meets a particular condition, or using RowQualifier this is similar to  FilteredRows but instead of typing the condition using VO attribute, we are write normal SQL condition.

Now let’s see an example using the first option:

OAApplicationModule oaapplicationmodule = pageContext.getApplicationModule(webBean);
DeptEOVOImpl deptEOVO = 
(DeptEOVOImpl)oaapplicationmodule.findViewObject("DeptEOVO");

DeptEOVORowImpl deptEOVORow = null;

RowSetIterator deptRowSetIter = deptEOVO.createRowSetIterator("DeptRowSetIter");

while(deptRowSetIter.hasNext())
{
deptEOVORow = (DeptEOVORowImpl)deptRowSetIter.next();
System.out.println("DeptID-->"+ deptEOVORow.getDeptId() + " Dept Name-->"+ deptEOVORow.getDeptName());

}
deptRowSetIter.closeRowSetIterator();