Database Reference
In-Depth Information
DECLARE
l_sql VARCHAR2(500);
BEGIN
l_sql := l_sql || q'!
SELECT
subject,
created_on,
assigned_to
FROM
tickets t,
status_lookup sl
WHERE
t.status_id = sl.status_id
AND sl.status = 'OPEN'
!';
IF :APP_USER = 'nobody' THEN
l_sql := l_sql || q'! AND public_flag = 'Y'
!';
END IF;
RETURN l_sql;
END;
To see the results of this report fully, you need to set a few tickets with the new
PUBLIC setting. Navigate to the ticket summary screen as a logged-in user, and
change a few OPEN tickets to have the PUBLIC option set to Yes. When you navigate
to the home screen as a logged-in user, a full list of open tickets should appear, as
shown in
Figure 8-47
. After logging out, you see only the tickets that have been identi-
fied as PUBLIC.
