This content has been marked as final. Show 4 replies
Dear 975204 ,
Would you build an example (as start point of discussion to reach solution) of your problem on apex.oracle.com
and provide workspace/developer account
when I request a work space apex.oracle.com it gives me the latest version of Apex. This client is on Apex 3.0. But aside from that, the client is a munciple government. I cant be posting an example that displays their internal data.
What I'm trying to do seems pretty standard design in every other programming language or tool I've used.
Right now, when a user logs on they have several options for searching for records; by last name, by department, by agency
Department and agency searches are by drop down lists. Last name is by entering text.
I have all of these working.
For a search from a drop down list, I have a main menu, the user selects an item from the list and it displays results on a new page
For a search by name, it display data on the same main menu page. I cant get it to open a new page
If if put all the look items on the first page, I am able to combine search options ( ie search by last name in a given department)
Ideally I like to have all search results open in a new page
on a related question, is there a way to reset the position on a drop down?
when I first login to the app, the cursor points to the first option on the drop down which is no option selected.
If a user selects some criteria , does a search, and then goes back to the search page, the cursor is no position on the item they previously searched on, not the no option selected option
RE: APEX 4.x vs. 3.0.
Just do the best you can. Try to use only 3.0 features when you do an example. I fully understand that you can't use real data -- or anything real -- menu selection, categories, etc., etc. Just make up something descriptive.
Yes, you can give a select list a value in the header before the region displays if you don't want it to default to "start over".
Some sample code where -- in the ELSE -- I set the value of the select list variable so that's the value it displays. In the THEN, I save the current value into a global (Application) item.
Begin IF (:F217_PAGE_NAME_FLAG = 'Month') THEN SELECT :P3_SL_SYS_NIC_NM INTO :F217_SYS_NIC_NM FROM DUAL; ELSE SELECT :F217_SYS_NIC_NM INTO :P3_SL_SYS_NIC_NM FROM DUAL; SELECT 'Month' INTO :F217_PAGE_NAME_FLAG FROM DUAL; END IF; End;