Database Reference
In-Depth Information
•
Run On Demand Process
: Calls an application-level on-demand process
•
Plug-ins
: Processes functionality provided by plug-ins
Processes in the Help Desk Application
The details behind processes can be very complex. In order to provide an adequate ex-
ample, let's include a simple process in the Help Desk application: a requirement that
the application keep track of the last time a record was modified. You can do this by
updating a Last Updated date on the record every time it's saved. There's more than
one way to accomplish this task. Here you do it with a process.
First, you need to add the
LAST_UPDATED
field to the
TICKETS
table. To do this
you use the SQL Workshop again:
1.
From the
SQL Workshop
drop-down menu, choose
Object Browser
, as
shown in
Figure 8-28
.
Figure 8-28.
Navigating to the SQL Workshop Object Browser
2.
Select the
TICKETS
table from the list of objects at left.
3.
