Database Reference
In-Depth Information
Figure 8-43.
Specifying a database column and a default value
15.
Drag and drop
P210_PUBLIC_FLAG
in the Page Rendering tree so it's
under
P210_STATUS_ID
, similar to
Figure 8-44
.
This is strictly for ease
of reading and usability.
Figure 8-44.
Layout modification for easier usability
Now that you have a
PUBLIC_FLAG
column in your data model and the ability to
control it through the Tickets form, you can create the dynamic SQL report on page 1
to display tickets with a Public option for unauthenticated users: