vw_private_store_collection_offers

Creates, updates, deletes, gets or lists a vw_private_store_collection_offers resource.

Overview

Name	vw_private_store_collection_offers
Type	View
Id	azure_extras.marketplace.vw_private_store_collection_offers

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.uniqueOfferId') as "unique_offer_id",
JSON_EXTRACT(properties, '$.offerDisplayName') as "offer_display_name",
JSON_EXTRACT(properties, '$.publisherDisplayName') as "publisher_display_name",
JSON_EXTRACT(properties, '$.eTag') as "e_tag",
JSON_EXTRACT(properties, '$.privateStoreId') as "private_store_id",
JSON_EXTRACT(properties, '$.createdAt') as "created_at",
JSON_EXTRACT(properties, '$.modifiedAt') as "modified_at",
JSON_EXTRACT(properties, '$.specificPlanIdsLimitation') as "specific_plan_ids_limitation",
JSON_EXTRACT(properties, '$.updateSuppressedDueIdempotence') as "update_suppressed_due_idempotence",
JSON_EXTRACT(properties, '$.iconFileUris') as "icon_file_uris",
JSON_EXTRACT(properties, '$.plans') as "plans",
privateStoreId,
collectionId,
offerId
FROM azure_extras.marketplace.private_store_collection_offers
WHERE privateStoreId = 'replace-me' AND collectionId = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.uniqueOfferId') as "unique_offer_id",
json_extract_path_text(properties, '$.offerDisplayName') as "offer_display_name",
json_extract_path_text(properties, '$.publisherDisplayName') as "publisher_display_name",
json_extract_path_text(properties, '$.eTag') as "e_tag",
json_extract_path_text(properties, '$.privateStoreId') as "private_store_id",
json_extract_path_text(properties, '$.createdAt') as "created_at",
json_extract_path_text(properties, '$.modifiedAt') as "modified_at",
json_extract_path_text(properties, '$.specificPlanIdsLimitation') as "specific_plan_ids_limitation",
json_extract_path_text(properties, '$.updateSuppressedDueIdempotence') as "update_suppressed_due_idempotence",
json_extract_path_text(properties, '$.iconFileUris') as "icon_file_uris",
json_extract_path_text(properties, '$.plans') as "plans",
privateStoreId,
collectionId,
offerId
FROM azure_extras.marketplace.private_store_collection_offers
WHERE privateStoreId = 'replace-me' AND collectionId = 'replace-me';