Database Reference
In-Depth Information
Figure 8-34.
Setting the condition of the process to work only when the Save button is
clicked
At this point, the process has been created. Currently you don't show the Last Up-
dated date in the summary report. In order to see the value on the report, you need to
add the
LAST_UPDATED
column to the query from which the report draws data. That
report resides on page 200 of your application:
1.
Edit
Page 200
.
2.
Edit the
Tickets
region by double-clicking the region's name in the tree.
3.
Add the
LAST_UPDATED
date to the
Region Source
of the report, as in
the following SQL. Click
Apply Changes
when you're finished:
SELECT
"TICKETS"."TICKET_ID" "TICKET_ID",
"TICKETS"."SUBJECT" "SUBJECT",
"TICKETS"."DESCR" "DESCR",
"TICKETS"."ASSIGNED_TO" "ASSIGNED_TO",
"TICKETS"."CREATED_ON" "CREATED_ON",
"TICKETS"."CLOSED_ON" "CLOSED_ON",
"TICKETS"."CREATED_BY" "CREATED_BY",
"STATUS_LOOKUP"."STATUS" "STATUS"
,
"TICKETS"."LAST_UPDATED" "LAST_UPDATED"
FROM
"STATUS_LOOKUP",
"TICKETS"
WHERE "STATUS_LOOKUP"."STATUS_ID" =
"TICKETS"."STATUS_ID"
and upper(subject) like
