Previous Next JavaScript must be enabled to correctly display this content

## 3.11.11.1.4 Listing Applications

Use SQLcl to list all or selected APEX applications in a workspace.

- Listing All Applications
  List all installed APEX applications in a workspace.
- Listing Applications in a Workspace To See Last Changed Date and Time
  List all APEX applications in a workspace along with the date and time they last changed.
- Listing Only Applications in a Workspace Changed On or After a Given Date
  List all APEX applications in a workspace along with the date and time they were last changed on or after a given date.
- Listing Only Applications in a Workspace Changed by a Given User
  List all APEX applications in a workspace along with the date and time they were last changed by a particular user.

Parent topic: Exporting and Importing Using SQLcl

### 3.11.11.1.4.1 Listing All Applications

List all installed APEX applications in a workspace.

To list all installed applications to which the logged-in use has access, use the command `apex list`.

For example:

    SQL> apex list

    WORKSPACE_ID     WORKSPACE APPLICATION_ID APPLICATION_NAME         BUILD_STATUS    LAST_UPDATED_ON
    1908816359534887 EXAMPLES  106            Sample Interactive Grids Run and Develop 24-SEP-21
    1908816359534887 EXAMPLES  113            List Examples            Run and Develop 17-JAN-22
    1908816359534887 EXAMPLES  110            Books with Tags          Run and Develop 04-JAN-22

Parent topic: Listing Applications

### 3.11.11.1.4.2 Listing Applications in a Workspace To See Last Changed Date and Time

List all APEX applications in a workspace along with the date and time they last changed.

To list all applications in a workspace along with the date and time they were last changed, use the command `apex` with the `list` option and provide the workspace ID.

For example:

    LAST_UPDATED_ON APPLICATION_ID APPLICATION_NAME
    SQL> apex list -workspaceid 1908816359534887

    LAST_UPDATED_ON  APPLICATION_ID   APPLICATION_NAME
    2021-09-24 09:19 106              Sample Interactive Grids
    2022-01-04 15:53 110              Books with Tags
    2022-01-17 13:50 113              List Examples

Parent topic: Listing Applications

### 3.11.11.1.4.3 Listing Only Applications in a Workspace Changed On or After a Given Date

List all APEX applications in a workspace along with the date and time they were last changed on or after a given date.

To list only applications in a workspace that were changed on or after a given date, use the command `export` with the `list` option and provide the workspace ID and date in the `YYYY-MM-DD` format.

For example:

    SQL> apex list -workspaceid 1908816359534887 -changesSince 2022-01-15

    LAST_UPDATED_ON  APPLICATION_ID   APPLICATION_NAME
    2022-01-17 13:50 113              List Examples

Parent topic: Listing Applications

### 3.11.11.1.4.4 Listing Only Applications in a Workspace Changed by a Given User

List all APEX applications in a workspace along with the date and time they were last changed by a particular user.

To list all applications in a workspace that were last changed by a particular user, use the command `apex` with the `list` option with the workspace ID and a username.

The following example shows applications last changed in workspace `1908816359534887` by user `jane.green`:

    SQL> apex list -workspaceid 1908816359534887 -changesBy jane.green

    LAST_UPDATED_ON  APPLICATION_ID   APPLICATION_NAME
    2021-09-24 09:19 106              Sample Interactive Grids
    2022-01-17 13:50 113              List Examples

You can also combine the date-based and user-based filters.

For example:

    SQL> apex list -workspaceid 1908816359534887 -changesBy jane.green -changesSince 2022-01-15

    LAST_UPDATED_ON  APPLICATION_ID   APPLICATION_NAME
    2022-01-17 13:50 113              List Examples

Parent topic: Listing Applications