A-0730

🆓

Info

Always give an alias to pages.

APEX_APPLICATION_PAGES All APEX versions • Check and SQL-based Test

Rule Details

Severity Level: Minor
Quality Area: Maintainability
Fixing times: 1 mins

Quick Fix | Local-easy
Database Support: OracleDB (v7.3.4 +)

Reason

A Page Alias is a unique alphanumeric identifier for a page. It appears in the browser URL path to provide a descriptive location. If none is set, the page ID is used instead.

Example

Non-Compliant Example

page 1 (
    name: Home
    // ...
)

Compliant Solution - ★★★★★

page 1 (
    name: Home
    alias: HOME
    // ...
)

Tests

Test SQL query

select aa.workspace || '.' || aa.alias || '.' || ap.page_id as identifier,
       'Missing page alias in page ' || ap.page_id || ' of app ' 
       || aa.alias || ' in ' || aa.workspace || '.' as message
  from apex_application_pages ap
  join apex_applications aa
    on aa.application_id = ap.application_id 
       and aa.workspace = ap.workspace
 where ap.page_alias is null
   and ap.page_id != 0
   and aa.workspace in (#ApexWorkspaces#)

Test results

Identifier	Message	Migration
WORKSPACE.CUSTOMERS.1	Missing page alias in page 1 of app CUSTOMERS in WORKSPACE.	-

Parameters

Use parameters to customize the rule to your needs.

Parameter	Description	Default Value
ApexWorkspaces	Comma-separated List of APEX workspaces owning APEX applications to check.	dblinter, dbl_gui

References

same as UC-0730