3.12.11.1.4 Listing Applications

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

Parent topic: Exporting and Importing Using SQLcl

3.12.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.12.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.12.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.12.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