vw_draft_packages
Creates, updates, deletes, gets or lists a vw_draft_packages resource.
Overview
| Name | vw_draft_packages |
| Type | View |
| Id | azure_extras.test_base.vw_draft_packages |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
JSON_EXTRACT(properties, '$.applicationName') as "application_name",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.draftPackagePath') as "draft_package_path",
JSON_EXTRACT(properties, '$.workingPath') as "working_path",
JSON_EXTRACT(properties, '$.appFileName') as "app_file_name",
JSON_EXTRACT(properties, '$.sourceType') as "source_type",
JSON_EXTRACT(properties, '$.useSample') as "use_sample",
JSON_EXTRACT(properties, '$.comments') as "comments",
JSON_EXTRACT(properties, '$.intuneMetadata') as "intune_metadata",
JSON_EXTRACT(properties, '$.highlightedFiles') as "highlighted_files",
JSON_EXTRACT(properties, '$.packageTags') as "package_tags",
JSON_EXTRACT(properties, '$.editPackage') as "edit_package",
JSON_EXTRACT(properties, '$.packageId') as "package_id",
JSON_EXTRACT(properties, '$.useAutofill') as "use_autofill",
JSON_EXTRACT(properties, '$.executableLaunchCommand') as "executable_launch_command",
JSON_EXTRACT(properties, '$.processName') as "process_name",
JSON_EXTRACT(properties, '$.tabState') as "tab_state",
JSON_EXTRACT(properties, '$.testTypes') as "test_types",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.targetOSList') as "target_os_list",
JSON_EXTRACT(properties, '$.inplaceUpgradeOSPair') as "inplace_upgrade_os_pair",
JSON_EXTRACT(properties, '$.lastModifiedTime') as "last_modified_time",
JSON_EXTRACT(properties, '$.flightingRing') as "flighting_ring",
JSON_EXTRACT(properties, '$.firstPartyApps') as "first_party_apps",
JSON_EXTRACT(properties, '$.galleryApps') as "gallery_apps",
JSON_EXTRACT(properties, '$.tests') as "tests",
JSON_EXTRACT(properties, '$.intuneEnrollmentMetadata') as "intune_enrollment_metadata",
subscriptionId,
resourceGroupName,
testBaseAccountName,
draftPackageName
FROM azure_extras.test_base.draft_packages
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND testBaseAccountName = 'replace-me';
SELECT
json_extract_path_text(properties, '$.applicationName') as "application_name",
json_extract_path_text(properties, '$.version') as "version",
json_extract_path_text(properties, '$.draftPackagePath') as "draft_package_path",
json_extract_path_text(properties, '$.workingPath') as "working_path",
json_extract_path_text(properties, '$.appFileName') as "app_file_name",
json_extract_path_text(properties, '$.sourceType') as "source_type",
json_extract_path_text(properties, '$.useSample') as "use_sample",
json_extract_path_text(properties, '$.comments') as "comments",
json_extract_path_text(properties, '$.intuneMetadata') as "intune_metadata",
json_extract_path_text(properties, '$.highlightedFiles') as "highlighted_files",
json_extract_path_text(properties, '$.packageTags') as "package_tags",
json_extract_path_text(properties, '$.editPackage') as "edit_package",
json_extract_path_text(properties, '$.packageId') as "package_id",
json_extract_path_text(properties, '$.useAutofill') as "use_autofill",
json_extract_path_text(properties, '$.executableLaunchCommand') as "executable_launch_command",
json_extract_path_text(properties, '$.processName') as "process_name",
json_extract_path_text(properties, '$.tabState') as "tab_state",
json_extract_path_text(properties, '$.testTypes') as "test_types",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.targetOSList') as "target_os_list",
json_extract_path_text(properties, '$.inplaceUpgradeOSPair') as "inplace_upgrade_os_pair",
json_extract_path_text(properties, '$.lastModifiedTime') as "last_modified_time",
json_extract_path_text(properties, '$.flightingRing') as "flighting_ring",
json_extract_path_text(properties, '$.firstPartyApps') as "first_party_apps",
json_extract_path_text(properties, '$.galleryApps') as "gallery_apps",
json_extract_path_text(properties, '$.tests') as "tests",
json_extract_path_text(properties, '$.intuneEnrollmentMetadata') as "intune_enrollment_metadata",
subscriptionId,
resourceGroupName,
testBaseAccountName,
draftPackageName
FROM azure_extras.test_base.draft_packages
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND testBaseAccountName = 'replace-me';