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.

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:

The COMPONENT_TYPE:ID values returned in the ID column can be useful as input to the -expComponents option described in Exporting Only Selected Application Components.

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:

The COMPONENT_TYPE:ID values returned in the ID column can be useful as input to the -expComponents option described in Exporting Only Selected Application Components.

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:

The COMPONENT_TYPE:ID values returned in the ID column can be useful as input to the -expComponents option described in Exporting Only Selected Application Components.