vw_private_store_collections

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

Overview

Name	vw_private_store_collections
Type	View
Id	azure_extras.marketplace.vw_private_store_collections

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, '$.collectionId') as "collection_id",
JSON_EXTRACT(properties, '$.collectionName') as "collection_name",
JSON_EXTRACT(properties, '$.claim') as "claim",
JSON_EXTRACT(properties, '$.allSubscriptions') as "all_subscriptions",
JSON_EXTRACT(properties, '$.approveAllItems') as "approve_all_items",
JSON_EXTRACT(properties, '$.approveAllItemsModifiedAt') as "approve_all_items_modified_at",
JSON_EXTRACT(properties, '$.subscriptionsList') as "subscriptions_list",
JSON_EXTRACT(properties, '$.enabled') as "enabled",
JSON_EXTRACT(properties, '$.numberOfOffers') as "number_of_offers",
JSON_EXTRACT(properties, '$.appliedRules') as "applied_rules",
privateStoreId,
collectionId
FROM azure_extras.marketplace.private_store_collections
WHERE privateStoreId = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.collectionId') as "collection_id",
json_extract_path_text(properties, '$.collectionName') as "collection_name",
json_extract_path_text(properties, '$.claim') as "claim",
json_extract_path_text(properties, '$.allSubscriptions') as "all_subscriptions",
json_extract_path_text(properties, '$.approveAllItems') as "approve_all_items",
json_extract_path_text(properties, '$.approveAllItemsModifiedAt') as "approve_all_items_modified_at",
json_extract_path_text(properties, '$.subscriptionsList') as "subscriptions_list",
json_extract_path_text(properties, '$.enabled') as "enabled",
json_extract_path_text(properties, '$.numberOfOffers') as "number_of_offers",
json_extract_path_text(properties, '$.appliedRules') as "applied_rules",
privateStoreId,
collectionId
FROM azure_extras.marketplace.private_store_collections
WHERE privateStoreId = 'replace-me';