Binding additional parameters to a VO that already have a binding parameter
973208Nov 8 2012 — edited Nov 9 2012I have an ADF project with a Form Based Authentication. I bind username of the login page to every View Object and filter all data from begining. All view objects have a bind variable with " adf.context.securityContext.userName" in their where clause. What I want to do is binding a second parameter to filter data once again after page is rendered with just userName condition.
So query of my VO is basicly like "select name,date from table where name =:p_name and date=:p_date"
Value for p_name is "adf.context.securityContext.userName" and it will be passed initially to VO. Than I want to pass the second parameter (p_date) from user input (like inout text),which I couldn't do it by ExecuteWithParams operation, and filter data once again.
What I could do so far is rendering page with just userName,second part is still missing. Any suggestion?
Thanks in advance
Regards
Murat