Advanced Interactive Reporting - Expert Oracle Application Express - page 559

The data within the activity log is available within the APEX ACTIVITY LOG view and the new column
is named IR SEARCH . You can write an interactive report in your application that will display all searches
within each report in your application. The SQL would look something like:
select APPLICATION ID, PAGE ID, PAGE NAME, IR SEARCH
from APEX WORKSPACE ACTIVITY LOG
where APPLICATION ID = 33368
and IR SEARCH IS not null
To find the most searched terms, the SQL would look something like this:
select APPLICATION ID, PAGE ID, PAGE NAME, IR SEARCH, count(*) cnt
from APEX WORKSPACE ACTIVITY LOG
where IR SEARCH IS not null
group by APPLICATION ID, PAGE ID, PAGE NAME, IR SEARCH
order by APPLICATION ID, PAGE ID, cnt desc
Keep in mind that logging activity is rotated between two different log tables. Because of this,
logging information is only as current as the oldest available entry in the logs. If you want to persist your
activity log data, you must copy the log information into your own application table.
Security
There are times when an application should show a column or edit link to only some users, based upon
an access control list (ACL) that the application maintains. If this is data dependent, you can create that
link using the dynamic link creation discussed above. If instead the edit link should always be displayed
to Administrators and never displayed to regular users then you can just create a report-level or column-
level condition. Just like conditions for almost every attribute in an application, you can select from the
predetermined list as shown in Figure 13-40 (always the fastest from a performance perspective) or
define a custom one using PL/SQL. If your condition is already expressed within an authorization
scheme, you don't need to create a condition—you can just associate that scheme to the column or
report link.
Figure 13-40 . Report column, authorization