Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating a main menu with searc / look up criteria

NuenhundretfunfundsiebzigJan 25 2013 — edited Jan 28 2013
I'm using Apex 3.0 for a client
I'm trying to create a main menu where the user can enter search criteria and when they click submit, it takes them to a different page to view the data
The main menu needs to just show the look up criteria, not display any data

I found documentation that shows me how to use list of values to do this where a drop down appears on the main menu, the user selects a category and then clicks on a button to take them to a separate page to display the formatted data.

I've got this working for several look ups

I also want to do a look up with a text field (last name) , where there is no list of values

I found documentation ( how to create a Parameterized Report) that shows me how to do this by creating a report on the page using a query with

WHERE
(lower(firstname) like '%' || lower(:P1_NAME) || '%' OR
lower(lastname) like '%' || lower(:P1_NAME) || '%')
where P1_NAME is a text item on the region and there is also a hidden item

The problem is that this displays the data on the same page that the report is on ( in this case the menu screen)

How can I incorporate something like this query but have the application branch to a different page to display the results? Any documentation that does something like this? Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2013
Added on Jan 25 2013
4 comments
215 views