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

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

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 export with the -list option and provide the workspace ID.

For example:

SQL> apex export -list -workspaceid 1908816359534887

Date             ID     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

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 apex export with the -list option and provide the workspace ID and date in the YYYY-MM-DD format.

For example:

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

Date             ID     Name
---------------- ------ -----------------------
2022-01-17 13:50 113    List Examples

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 exportwith 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 export -list -workspaceid 1908816359534887 -changesBy jane.green

Date             ID     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 export -list -workspaceid 1908816359534887 -changesBy jane.green -changesSince 2022-01-15

Date             ID     Name
---------------- ------ -----------------------
2022-01-17 13:50 113    List Examples