I have an ADF project with a Form Based Authentication. I bind username (adf.context.securityContext.userName) to every View Object and filter all data from begining. 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 table1" and it should be executed with two parameters ( first p_name and then 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 input text),which I couldn't do it by ExecuteWithParams operation, and filter data once again.
The datas are spesific to each user and other users should not reach any data because it's a critical task for the suplier. View Criteria also is not a solution because somehow they can query the VO with userName input and reachother users information.
What I could do so far is rendering page with just userName,second part is still missing. There is a strange situation because when I try to bind userName once again, it's emptied.That's why ExecuteWithParams also doesn't work.
add a view criteria (create first) to the View Object instance (AM --> Data Model --> right mouse click on VO --> choose Edit) to further filter the query. This view criteria can then have bind variables.