Database Reference
In-Depth Information
Figure 13-14.
APEX Advisor options
The Advisor is an excellent tool to help detect issues before your application is de-
ployed to end users. It's still important to have development standards and a release
process to help prevent issues. You should be aware that the Advisor might produce
false positives in response to some of the business rules in your organization, so you
should analyze each suggestion before fixing it.
Build Options
Build options let the developer conditionally include or exclude certain features of the
application at runtime. Build options are either enabled or disabled for the entire ap-
plication and can only be changed in the Application Builder. This means they aren't
runtime configuration options.
Understanding the Need
Suppose you're working on a custom authentication scheme and you want to verify
that the appropriate authentication results and custom status messages are populating in
the activity log for invalid login attempts. Each time you attempt a login, you could
switch programs and run a query against APEX_WORKSPACE_ACCESS_LOG. This
process might get cumbersome because you'd have to toggle between two applications.
An alternate solution is to create a report on the Login page to display the most recent
login attempts. After each bad login attempt, you can return to the Login page and see
an updated Login Attempts report.
To build this report on page 101, the Login page, create a report with the following
query:
SELECT user_name,
authentication_method,
access_date,
authentication_result,
custom_status_text
FROM apex_workspace_access_log
WHERE application_id = :app_id
ORDER BY access_date DESC
