Database Reference
In-Depth Information
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 gen-
erated 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 en-
gine to produce the chart.
