3.12.11.1.5 Listing Components in an Application
Use SQLcl to list all or selected components in an APEX application.
- Listing Components in an Application
List all components in an APEX application. - Listing Components in an Application Changed On or After a Given Date
List components in an APEX application changed on or after a given date. - Listing Components in an Application Changed by a Given User
List components in an APEX application changed by a given user.
Parent topic: Exporting and Importing Using SQLcl
3.12.11.1.5.1 Listing Components in an Application
List all components in an APEX application.
To list all components in an application, use the command apex
export
with the -list
option and provide the
application ID.
For example:
SQL> apex export -list -applicationid 113
Date ID Name
---------------- --------------------------------------- -----------------------
2022-01-16 13:27 AUTHENTICATION:8357166163330009 Application Express Accounts
2022-01-16 13:27 AUTHORIZATION:8548023343331081 Administration Rights
2022-01-16 13:27 BREADCRUMB:8357461593330012 Breadcrumb
:
2022-01-16 13:27 PAGE:0 0. Global Page
2022-01-16 13:27 PAGE:9999 9999. Login Page
2022-01-16 13:27 PAGE_TEMPLATE:8358297610330029 Drawer
:
2022-01-16 13:27 POPUP_LOV_TEMPLATE:8522686443330703 Search Dialog
2022-01-16 13:27 REGION_TEMPLATE:8388699844330160 Alert
Tip:
TheCOMPONENT_TYPE:ID
values returned in the ID
column can be useful as input to the -expComponents
option
described in Exporting Only Selected Application Components.
Parent topic: Listing Components in an Application
3.12.11.1.5.2 Listing Components in an Application Changed On or After a Given Date
List components in an APEX application changed on or after a given date.
To list components in an application changed on or after a given date,
use the the command apex export
with the -list
option and provide the application ID
and date in the
YYYY-MM-DD
format.
For example:
SQL> apex export -list -applicationid 113 -changesSince 2022-01-14
Date ID Name
---------------- --------------------------------------- -----------------------
2022-01-14 13:27 BREADCRUMB:8357461593330012 Breadcrumb
2022-01-16 13:27 AUTHENTICATION:8357166163330009 Application Express Accounts
2022-01-16 13:27 AUTHORIZATION:8548023343331081 Administration Rights
:
2022-01-16 13:27 PAGE:0 0. Global Page
2022-01-16 13:27 PAGE:9999 9999. Login Page
2022-01-16 13:27 PAGE_TEMPLATE:8358297610330029 Drawer
Tip:
TheCOMPONENT_TYPE:ID
values returned in the ID
column can be useful as input to the -expComponents
option
described in Exporting Only Selected Application Components.
Parent topic: Listing Components in an Application
3.12.11.1.5.3 Listing Components in an Application Changed by a Given User
List components in an APEX application changed by a given user.
To list components in an APEX application changed by a particular user, use the command apex
export
with the -list
option and include the
application ID and a username.
The following example lists changed components in the application
113
by jane.green
:
SQL> apex export -list -applicationid 113 -changesBy jane.green
Date ID Name
---------------- --------------------------------------- -----------------------
2022-01-14 13:27 BREADCRUMB:8357461593330012 Breadcrumb
2022-01-16 13:27 PAGE:0 0. Global Page
2022-01-16 13:27 PAGE:9999 9999. Login Page
You can also combine the date-based and user-based filters as follows:
SQL> apex export -list -applicationid 113 -changesBy jane.green -changesSince 2022-01-15
Date ID Name
---------------- --------------------------------------- -----------------------
2022-01-16 13:27 PAGE:0 0. Global Page
2022-01-16 13:27 PAGE:9999 9999. Login Page
Tip:
TheCOMPONENT_TYPE:ID
values returned in the ID column can be
useful as input to the -expComponents
option described in Exporting Only Selected Application Components.
Parent topic: Listing Components in an Application