Hi
In my application users have in their homepage a region that has two simple things an SLECT-LIST Item based on lov and a BUTTON
There is also another page that has a normal report which shows the employees.
On the homepage user can select in his “SLECT-LIST” some department number and click BUTTON “open”.
And for example: if the user selected a DEP_NUM_5 and click BUTTON he will be redirected to the page with a report and gets only shown the employees that belongs to department 5.
The report page has a simple SQL Query and I understand that somehow I must pass the value from the SELECT LIST to where I have now the “???????”.
How can I do this, where should I start?
Of course I would really appreciate some code example if someone have time to do one.
select "EMP_ID",
"EMP_FORNAME",
"EMP_SURNAME",
"DEP_NUMBER"
from EMP E
where E.DEP_NUMBER = ????????