Databases Reference
In-Depth Information
f?p=&APP_ID.:
9
:&SESSION.
4.
Save and apply your changes. Now run your application by clicking the
Run
Application
icon. The application will now redirect you to the front end
catalog page.
How It Works
As mentioned in Chapter 9, a typical link to a page in APEX has the following format:
f?p=(ApplicationID):(PageNumber):(SessionID):::::
This recipe shows you the
&APP_ID.
and
&SESSION.
substitution tags to dynamically place the application
ID and session identifier respectively in the final generated link. In this recipe, the page number (id:
9
) is
hardcoded in the link.
10-5. Creating the Stockcount Report for the Storekeeper
Problem
The storekeeper's boss wants to see a visual report (pie chart) of the number of books (stockcount) by
genre.
Solution
To create the stockcount pie chart, please follow these instructions:
1.
In the same
Book catalog
application, create a new page.
2.
Choose the
Chart
page type, and in the next step of the wizard, opt for the
Flash Chart
type.
3.
Choose the
Pie & Doughnut
chart type, as shown in Figure 10-24.