 |
|
Oracle Tips by Burleson |
Create
an Item to use in the Filter Criteria
The next step will create a page item to use in
the WHERE clause of the report SQL statement to filter the Last Name
column. This process should be familiar by now. It is the same
process used when creating the P11_REPORT_SEARCH page item earlier in
the chapter.
Create a new Text item, named P11_LAST_NAME,
sequence set to 20, in the Filter Criteria region, the rest is
default.
Add a Page Item to the
Filter the SQL Report
The previous example created a page item to use in
the WHERE clause. Now it needs to be added to the SQL statement for
the report.
Navigate to the Region Definition page for the
Conference – Confirmed Attendees report. Replace the current
statement in the Region Source to the statement in the file ch7_3.sql
in the code depot.
Save the changes and can run the report to see how
it works.
Creating Multiple Items
This feature allows the creation of multiple items
on an application page in a very short time. These items can be built
in multiple regions. I once used this feature to build ten pages in
one evening so a colleague could show them to the client the next
morning. I can’t begin to tell you how excited they were to come in
the next morning to see their vision of an application before their
eyes.
To create the remaining page items, navigate to
the page definitions page and click on the  icon
in the Items area.
On the Item Type page, click on the Create
multiple items link below the Create Item region. This will navigate
to a page similar to the one shown in Figure 7.11. In Figure 7.11,
all the items have been filled in. Do the same making sure to select
the Region as shown and number the sequences indicated.
Once all the information has been filled in, click
the Create Multiple Items button.
Once the page items are created, it will be
necessary to modify the SQL statement for the report one final time.
Change it to the SQL contained in file ch7_4.sql:
Run the report again and try entering some values
for the filter criteria and press the Go button. The Filter Criteria
region may not be laid out as you would like. A later chapter will
cover how to format page layout
Another desirable thing to do is modify the Reset
Report Search process for the page so it clears the page cache for all
items in the Filter Criteria region.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
