Syntax

SHOW WORKSPACE GROUPS [ LIKE '<pattern>' ]
    [ EXTENDED ] [ ORDER BY '<key>' [ ASC | DESC ],... ]
    [ LIMIT <limit> ]

Arguments

• pattern: Specifies a pattern similar to the SQL LIKE clause and returns workspace groups 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.

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

Example

The following command returns information on workspace groups that match the specified pattern:

SHOW WORKSPACE GROUPS LIKE 'Marketing%' EXTENDED ORDER BY Name;