Hi,
I am trying to create rowSet (Secondary) which should filter out rows that are updated in ViewObject from UI (probably transient attribute updation). I tried to set the quey mode of the viewObject to "ViewObject.QUERY_MODE_SCAN_VIEW_ROWS" and tried executing the query and get the rowSet. But instead of providing the filtered vlaued form the ViewObject, it queries form database and provide me false rowSet as follows,
ViewObject view = this.getEmp1();
RowSet rowSet = view.createRowSet(null); //secondary rowSet
rowSet.setNamedWhereClauseParam("BindFirstName","Jenifer");
view.setQueryMode(ViewObject.QUERY_MODE_SCAN_VIEW_ROWS);
rowSet.executeQuery();
System.out.println(rowSet.getEstimatedRowCount());
Instead of me getting 2 in the sop I get 107 as result. But I am able to see my updated records in the ViewObject. Is there a way to get out a filtered secondary row set form the updated transient values.
Regards,
Vijai