Databases Reference
In-Depth Information
•
SQL Expression
: Expression used in the
SELECT
portion of an SQL statement
•
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
.
Enter
P210_DAYS_OPEN
for
Item Name
. The other values can be left at the defaults,
as shown in Figure
8-22
. Click
Next
.
4.