Use the below method
to modify the query of a view object run time programmatically.
public void modfiy(ViewObjectImpl voImpl,
String newQueryString){
voImpl.setFullSqlMode(voImpl.FULLSQL_MODE_AUGMENTATION);
voImpl.closeRowSet();
voImpl.setWhereClause(null);
voImpl.setWhereClauseParams(null);
voImpl.setQuery(newQueryString);
}
