 |
|
Oracle Tips by Burleson |
Creating
a Report Link
Until now, every time the report was submitted it
returned to the same report. In other words, there was no navigation
to another web page. Now it is time to see how to navigate from the
report page to another application page. The report shows a list of
the rows, but the rows cannot be edited in a report, so the goal is to
navigate to a form page to edit a single record at a time. Until our
own form page is created in the next chapter, the navigation will be
to the existing form page that was created when the Conference RSVP
application was built in a previous chapter. The form page to which
the navigation will go is application page three.
The idea here is to modify the ID column in the
report to be a linked column that will navigate the user to page three
when the link is clicked. Navigating to the page is not all that is
needed. It will also be necessary to let page three know which record
the user wants to edit. This is done by sending the value of the ID
column in the URL when navigating to page three. Believe it or not,
all this work is handled in one section while modifying the properties
of the ID report column.
Before this lesson commences, take note of the ID
column in the report. It is a column with a column heading of ID and
it can be sorted. When finished, the column heading will be blank,
not sortable, and will have an icon the user can click on to be
navigated to the form page so the row can be edited.
Navigate to the page definition page and click on
the Report link as was shown in Figure 7.2.
1.
Before changing the heading of the ID column, first set the
Headings Type to Custom. Click on the Custom option in the Column
Attributes region, as shown in Figure 7.7.
2.
In the Column Attributes region, click on the  icon
next to the ID column.
This navigates to the page where all the
changes necessary to alter the look, feel, and behavior of the column
will be made.
3.
On the Column Attributes page:
·
In the Column Definition region, clear the text in the
Column Heading page item.
·
In the Column Link region: Link Text: Click on the [Icon
2] link below the Link Text page item.
The proper
syntax for the <img> tag will be filled in automatically. As the
mouse pointer is placed over each of the links, an image is displayed
in the area to the right.
·
Modify the text in the Link Text page item. Change the
alt tag text from alt=“Icon 2” to the following:
alt=“Click to edit #FIRST_NAME# #LAST_NAME#”
The columns returned in the query are
usable as substitution strings. This provides a good deal of
flexibility in the way they can be used to display information to the
user. What is happening here is modification of the text that will be
displayed when the mouse pointer is scrolled over the icon in the
report row, as shown in Figure 7.8. By using the query columns as
substitution strings, it is possible to display bubble text with data
from the report row.
4.
Target: Page in this Application.
Choosing this option just means the plan
is to navigate to another page in this application. To navigate to a
page in a different HTML DB application, the URL option would be
chosen.
5.
Page: Enter the value 3 to indicate to the page to which to
navigate when the Link icon is clicked.
6. Item
1 Name: Use the  icon
next to the Item 1 Name page item. This will display a popup window.
Click on the P3_ID link.
This is indicating a page item on another
page that will have its session state set when navigation is
transferred to the next page. If the name of the page item you are
going to set is known, it can be typed in manually. This method is
useful when you cannot remember the name of the item on the next page.
7.
Item 1 Value: Again, use the flashlight icon next to the Item 1
Value page item to display the popup window. Then click on the #ID#
link in the popup. If known, the value needed in this page item can
be typed in manually, but this way can be more useful when first
starting out with HTML DB because it is not always possible to
remember the correct syntax to use here.
8.
Click Apply Changes.
Run the report to see the link that will now show
up where the ID column is. Place the mouse over one of the links to
see the bubble text display with the First and Last name as shown in
Figure 7.8. Finally, click on one of the  icons
to be navigated to the Form page that allows the row to be edited.
Click the back button on the browser to go back
to the Report page. Do not click on the Cancel button as this will
navigate to page one in the application since that is how it was
built by the create application wizard.
 |
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. |
|
