Databases Reference
In-Depth Information
Figure 7-80.
Setting the default value for the new item P200_STATUS_ID
By default, the new item is placed on a new line. The fact that you chose 15 for the sequence places it between
the existing text field and the Go button. You need to edit the new select list so that it appears on the same line as the
search field:
9.
Edit the new field
P200_STATUS_ID
by double-clicking its name.
10.
In the
Grid Layout
section, set
Start New Row
to
No
, and click
Apply Changes.
Finally, you have to change the query for the Tickets report on page 200 to account for the value of the item
P200_STATUS_ID is set to:
11.
Edit the
Tickets
report on page 200 by double-clicking its name.
12.
Append the following line to the end of the query, and click
Apply Changes
:
AND tickets.status_id LIKE :P200_STATUS_ID
Now, run the application and navigate to the Chart page. Click any value in the chart, and that value should be
passed to the Tickets page and passed in to the Status filter. The resulting report should only display those records that
correspond to the status that was clicked in the chart.
Looking Behind the Scenes
Viewing the Chart page in the Application Builder, you see that the only element generated is the chart region in the
Page Rendering region, as shown in Figure
7-81
. The chart region is interesting in that it has a Series element, which
contains your SQL query. The chart region embodies the logic that passes your query to the AnyChart engine to
produce the chart.
