Databases Reference
In-Depth Information
Figure 7-76.
Setting the tab attributes for a chart
9.
Set
Chart Title
to
Ticket Statuses
, and click
Next
.
10.
Locate and open the file
ch7_query.txt
, which you can find where you extracted the topic
files. The contents of the file should be similar to this query:
SELECT
'f?p=&APP_ID.:200:' || :APP_SESSION || '::::P200_STATUS_ID:' || sl.status_id link,
sl.status label,
count(*) value
FROM
tickets t,
status_lookup sl
WHERE
t.status_id = sl.status_id
GROUP BY
sl.status_id, sl.status
ORDER BY
3 DESC
Paste the contents of the file
ch7_query.txt
into the
Enter SQL Query or PL/SQL
Function Returning a SQL Query
region, or type the previous query into the region, and
click
Next
.
11.
12.
Click
Create
.
Run the page. Your chart should look similar to the one in Figure
7-77
.
