Syntax

SHOW STAGE FILES [ { IN GROUP { ID '<deployment_ID>' | '<deployment_name>' } | IN { ID '<deployment_ID>' | '<deployment_name>' } } ]
    [ AT '<path>' ] [ LIKE '<pattern>' ]
    [ ORDER BY '<key>' [ ASC | DESC ],... ]
    [ LIMIT <limit> ] [ RECURSIVE ] [ EXTENDED ]

Arguments

• deployment_ID, deployment_name: The ID or name of the deployment in which the Stage is attached.

• path: A path in the Stage.

• pattern: Specifies a pattern similar to the SQL LIKE clause and returns files with names that match the specified pattern. Uses % as the wildcard character.

• key: Key used to sort the result set.

• limit: An integer value.

Remarks

• The LIMIT clause limits the number of results to the specified number.

• By default, the result is sorted in the ascending order.

• The IN and IN GROUP clauses specify the ID or name of the deployment (workspace group) in which the Stage is attached.

• Specify the RECURSIVE clause to list the files recursively.

• Specify the EXTENDED clause to return more information on the files.

Example

The following command lists the files at the specified path with additional information:

SHOW STAGE FILES IN 's2wsg' AT PATH "/data/" EXTENDED;