Database Reference
In-Depth Information
•
PL/SQL Expression
: Same as SQL Expression
•
Item Value
: Name of another item in the application
Computations can be conditional in the same manner as many of the other APEX
components. The conditions can be as complex as the business rules require with the
ability to use the database features and APEX session items to evaluate the condition.
Conditions evaluating to
TRUE
result in the computation being executed.
Creating a Computation
The Help Desk application has a requirement to display the number of days a ticket has
been open. The result should be a derived value and change depending on the day and
status of the record being reviewed. You accomplish this by putting a new item on the
page that displays the result of the computation:
1.
Edit
Page 210
.
Use the shortcut this time to create your page item:
2.
Right-click while hovering over the
Items
section in the
Manage Tickets
region of the Page Rendering tree shown in
Figure 8-21
, and click
Create
Page Item
.
Figure 8-21.
Using the shortcut menu to create a new page item
3.
Select
Display Only
, and click
Next
.
4.
Enter
P210_DAYS_OPEN
for
Item Name
. The other values can be left at
the defaults, as shown in
Figure 8-22
. Click
Next
.