Databases Reference
In-Depth Information
Figure 8-26.
Entering the SQL statement for a computation
SELECT
DECODE(status, 'CLOSED', closed, open_or_pending) days_open
FROM
(
SELECT
ROUND(sysdate - t.created_on) open_or_pending,
NVL(ROUND(t.closed_on - t.created_on),0) closed,
sl.status status
FROM
tickets t,
status_lookup sl
WHERE
t.status_id = sl.status_id
and t.ticket_id = :P210_TICKET_ID)
15.
Optionally, move the Days Open counter next to the Subject using drag and drop within the
tree. You can then position them on the same line by editing
P210_DAYS_OPEN
and setting
the
Start New Row
attribute to
No
. Figure
8-27
shows the element in its new position.
Figure 8-27.
Moving the item to its new position