app_catalog_listing_resource_versions
Creates, updates, deletes, gets or lists an app_catalog_listing_resource_versions resource.
Overview​
| Name | app_catalog_listing_resource_versions |
| Type | Resource |
| Id | oci.compute.app_catalog_listing_resource_versions |
Fields​
The following fields are returned by SELECT queries:
- get
- list
The listing resource version was retrieved.
| Name | Datatype | Description |
|---|---|---|
accessiblePorts | array | List of accessible ports for instances launched with this listing resource version. |
allowedActions | array | Allowed actions for the listing resource. |
availableRegions | array | List of regions that this listing resource version is available. For information about regions, see [Regions and Availability Domains](/iaas/Content/General/Concepts/regions.htm). Example: ["us-ashburn-1", "us-phoenix-1"] |
compatibleShapes | array | Array of shapes compatible with this resource. You can enumerate all available shapes by calling [ListShapes](#/en/iaas/latest/Shape/ListShapes). Example: ["VM.Standard1.1", "VM.Standard1.2"] |
listingId | string | The OCID of the listing this resource version belongs to. |
listingResourceId | string | OCID of the listing resource. |
listingResourceVersion | string | Resource Version. |
timePublished | string (date-time) | Date and time the listing resource version was published, in [RFC3339](https:​//tools.ietf.org/html/rfc3339) format. Example: 2018-03-20T12:32:53.532Z |
Listing Resource Version summary
| Name | Datatype | Description |
|---|---|---|
listingId | string | The OCID of the listing this resource version belongs to. |
listingResourceId | string | OCID of the listing resource. |
listingResourceVersion | string | Resource Version. |
timePublished | string (date-time) | Date and time the listing resource version was published, in [RFC3339](https:​//tools.ietf.org/html/rfc3339) format. Example: 2018-03-20T12:32:53.532Z |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | listingId, resourceVersion, region | Gets the specified listing resource version. | |
list | select | listingId, region | limit, page, sortOrder | Gets all resource versions for a particular listing. |
Parameters​
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
listingId | string | The OCID of the listing. |
region | string | OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION) |
resourceVersion | string | Listing Resource Version. |
limit | integer | For list pagination. The maximum number of results per page, or items to return in a paginated "List" call. For important details about how pagination works, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine). Example: 50 |
page | string | For list pagination. The value of the opc-next-page response header from the previous "List" call. For important details about how pagination works, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine). |
sortOrder | string | The sort order to use, either ascending (ASC) or descending (DESC). The DISPLAYNAME sort order is case sensitive. |
SELECT examples​
- get
- list
Gets the specified listing resource version.
SELECT
accessiblePorts,
allowedActions,
availableRegions,
compatibleShapes,
listingId,
listingResourceId,
listingResourceVersion,
timePublished
FROM oci.compute.app_catalog_listing_resource_versions
WHERE listingId = '{{ listingId }}' -- required
AND resourceVersion = '{{ resourceVersion }}' -- required
AND region = '{{ region }}' -- required
;
Gets all resource versions for a particular listing.
SELECT
listingId,
listingResourceId,
listingResourceVersion,
timePublished
FROM oci.compute.app_catalog_listing_resource_versions
WHERE listingId = '{{ listingId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND sortOrder = '{{ sortOrder }}'
;