Win a copy of GANs in ActionE this week in the AI forum
or WebAssembly in Action in the JavaScript forum!

Matthew Borden

Greenhorn
+ Follow
since Jun 23, 2010
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Matthew Borden

Hi,

I posted this earlier but thought I had resolved it (wrong).......New to JDev and Java (just earned my SCJA) and unable to find a way to return all rows when "no selection" item is selected in a dynamic SelectOneChoice. I want the user to be able to move back and forth from viewing all rows by selecting "no selection" and to view a filtered set of rows based on selected critera in the SelectOneChoice. To accomplish this I have been trying to code a custom method in the ViewObjectImpl file along with an InvokeAction in the page definition file, but I've so far been unsuccessful. Below is the most recent attempt to code the custom method in the ViewObjectImpl file:

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");
executeQuery();
}

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