Databases Reference
In-Depth Information
Figure 5-12.
The animated chart
How It Works
The concept behind most views in APEX is similar: the heart of a view consists of the SQL statement that
you feed it. APEX simply takes the dataset resulting from the SQL query (the dataset is expected to be in a
certain format) and displays it appropriately.
Chart views are no different conceptually from any other view. For pie charts specifically, APEX
always expects the second field in the SQL query to be the label that is displayed on the chart for the
series. The third field is the numerical value for that series.
Note
The format of the SQL query differs for different types of charts. You can always refer to the sample SQL
scripts provided in the same SQL definition page in the wizard. (APEX is nice enough to provide hints in their
wizards.)
