SHOW AVAILABLE LISTINGS¶

Lists the listings that are available to the user who runs the command. For more information, see Listing availability options.

See also:: CREATE LISTING, CREATE APPLICATION … FROM LISTING, ALTER LISTING, DESCRIBE LISTING, DROP LISTING,

Syntax¶

SHOW AVAILABLE LISTINGS

SHOW [ TERSE ] AVAILABLE LISTINGS
    [ LIMIT <rows> ]
    [ IS_IMPORTED = TRUE ]
    [ IS_ORGANIZATION = TRUE ]
    [ IS_SHARED_WITH_ME = TRUE ]

Copy

Parameters¶

LIMIT rows

Optionally limits the maximum number of rows returned, while also enabling “pagination” of the results. The actual number of rows returned might be less than the specified limit. For example, the number of existing objects is less than the specified limit.

TERSE

Optionally returns output containing only the following columns:

created_on
global_name
title
profile

IS_SHARED_WITH_ME = TRUE

Optional, shows only listings shared privately with the current user.

Property value

Behavior

Not set

All listings are returned.

TRUE

Only listings shared privately with the current user are returned.

IS_IMPORTED = TRUE

Optional, shows only imported listings, but filters returned results according to:

Property value	Behavior
Not set	All listings are returned.
TRUE	Only imported listings are returned.

IS_ORGANIZATION = TRUE

Optional, shows only organization level listings.

Property value	Behavior
Not set	All listings are returned.
TRUE	Shows organization level listings.

Usage notes¶

Only one of filters IS_IMPORTED, IS_ORGANIZATION, or IS_SHARED_WITH_ME may be specified at a time.