Retrieve Rows without changing Viewobject default Rowset

Sometimes we might want to retrieve row(s) from a view object based on certain view criteria without disturbing the default rowset for the view object...

FindByViewCriteria API comes to the rescue...

BigDecimal value= new BigDecimal(100);

ViewObjectImpl myVO = getMyViewObjectVO1();

 ViewCriteria vc = myVO.getViewCriteria("findByVC");

 vc.ensureVariableManager().setVariableValue("MyId1",value);

 RowIterator byViewCriteria = myVO.findByViewCriteria(vc, 1,siteRef.QUERY_MODE_SCAN_VIEW_ROWS);

   if(byViewCriteria.hasNext()){

              Row row = byViewCriteria.next();

              oracleCustomerId=(BigDecimal)row.getAttribute("OrderTotal");

   }

See the documentation http://docs.oracle.com/cd/E15523_01/apirefs.1111/e10653/oracle/jbo/RowIterator.html