Databases Reference
In-Depth Information
ENAME LABEL,
SAL VALUE
FROM EMP
where deptno = nvl(:P8_DEPTNO, deptno)
ORDER BY ENAME
If you want to create the above example yourself while you are reading, have a look at Figure 2-67,
which shows all the regions, buttons and items behind the scenes and how they are laid out. If you
downloaded the application that belongs to this chapter, you should have a look at page 8.
Note that the pie chart has a link defined. That link will submit the page and set the item
P8_DEPTNO
,
a hidden item we created in that region, with the value of the slice the user clicks.
We also use a button on the page called All Departments which redirects to the same page and
clears the cache. When creating the button for the action, select Redirect to Page in this Application, (the
Page is 8 and Clear Cache is 8). Figure 2-67 shows how the rendering of page 8 looks, where no page
processing has been defined.
Figure 2-67.
Behind the scenes of the simple dashboard page with Submit
This example is the simplest dashboard you can create. It uses charts created by the wizard and
provides interactivity and drill-down capabilities by using the link in the series SQL statement. To
achieve the dashboard look and feel, we created a parent region with three subregions for the charts.
That way the charts look like they are combined. The above example has one big drawback: whenever
the manager clicks on a link the entire page gets submitted, which isn't a nice effect and doesn't flow
that well.
Simple Dashboard with JavaScript
This example will expand on the previous example, extending it to include a report on the employee
data. Rather than doing a submit of the entire page, we will just refresh the necessary regions so the
manager gets a nicer user experience.
