Oracle JDev 10.1.3 (JSF, ADF BC) SelectOneChoice

[Matthew Borden]

Hi,

New to JDev and Java (just earned my SCJA last Friday) and unable to find a way to return all rows when "no selection" item is selected in a SelectOneChoice. I want the user to be able to move back and forth from all rows by selecting "no selection" and to view a filtered set of rows based on selected critera in the SelectOneChoice.

I thought the following would work in my ViewObject Impl file along with a dynamic select one choice:

public void testmbq(String testthisp){
if (testthisp != null) {
setWhereClause("IPEDS_CAT_ID = :TheId");
defineNamedWhereClauseParam("TheId", null, null);
setNamedWhereClauseParam("TheId", testthisp);
executeQuery();}
else {
skipNamedWhereClauseParam("IPEDS_CAT_ID = :TheId");
removeNamedWhereClauseParam("TheId");
executeQuery();
}

Unfortunately, I cannot get all rows from my viewobject to return when the SelectOneChoice is submitted with <no selection>.

Thanks