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, ALTER LISTING, DESCRIBE LISTING, DROP LISTING

语法

SHOW AVAILABLE LISTINGS

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

参数

LIMIT rows

（可选）限制返回的最大行数，同时还对结果启用“分页”功能。返回的实际行数可能小于指定的限制。例如，现有对象的数量小于指定的限制。

TERSE

（可选）返回仅包含以下列的输出：

  • created_on
  • global_name
  • profile
  • title
IS_SHARED_WITH_ME = TRUE

可选，仅显示与当前用户私密共享的列表。

Property valueBehavior
Not setAll listings are returned.
TRUEOnly listings shared privately with the current user are returned.
IS_IMPORTED = TRUE

可选，只显示导入的列表，但会根据以下条件筛选返回的结果：

Property valueBehavior
Not setAll listings are returned.
TRUEOnly imported listings are returned.
IS_ORGANIZATION = TRUE

可选，仅显示组织级别列表。

Property valueBehavior
Not setAll listings are returned.
TRUEShows organization level listings.

使用说明

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