Databases Reference
In-Depth Information
4.
Enter the following SQL statement in the text area, replacing the current statement, and
click
Run
. This updates all the current tickets to a default value of
N
:
UPDATE tickets SET public_flag = 'N'
Now that the data-model modifications are complete, you can move on to the application. Add the option to see
and edit the new value in the ticket edit screen:
5.
Click the
Application Builder
tab.
6.
Select the
Help Desk
application by clicking the corresponding icon or link.
7.
Edit
Page 210
of the application.
8.
Add an item to the
Manage Tickets
region by right-clicking the region's name and
selecting
Create Page Item
, as shown in Figure
8-38
.
Figure 8-38.
Adding a page item to be your public flag
9.
Select
Radio Group
as
Item Type
, and click
Next
.
Enter
P210_PUBLIC_FLAG
for
Item Name
, as shown in Figure
8-39
, select
Manage Tickets (0)
for
Region
, and click
Next
.
10.