Previous Next JavaScript must be enabled to correctly display this content

## 3.11.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.11.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` with the `list` option and provide the application ID.

For example:

    SQL> apex list -applicationid 113

    LAST_UPDATED_ON  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.

Parent topic: Listing Components in an Application

### 3.11.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` with the `list` option and provide the application `ID` and date in the `YYYY-MM-DD` format.

For example:

    SQL> apex list -applicationid 113 -changesSince 2022-01-14

    LAST_UPDATED_ON  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.

Parent topic: Listing Components in an Application

### 3.11.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` 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 list -applicationid 113 -changesBy jane.green

    LAST_UPDATED_ON  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 list -applicationid 113 -changesBy jane.green -changesSince 2022-01-15

    LAST_UPDATED_ON  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.

Parent topic: Listing Components in an Application