@@ -55,7 +55,6 @@ WITH latest_prebuilds AS (
55
55
workspaces .name ,
56
56
workspaces .template_id ,
57
57
workspace_latest_builds .template_version_id ,
58
- workspace_latest_builds .template_version_preset_id ,
59
58
workspace_latest_builds .job_id ,
60
59
workspaces .created_at
61
60
FROM workspace_latest_builds
@@ -66,11 +65,13 @@ WITH latest_prebuilds AS (
66
65
AND NOT workspaces .deleted
67
66
),
68
67
workspace_latest_presets AS (
69
- SELECT DISTINCT ON (latest_prebuilds .id ) latest_prebuilds .id AS workspace_id,
70
- workspace_builds .template_version_preset_id AS current_preset_id
68
+ SELECT DISTINCT ON (latest_prebuilds .id )
69
+ latest_prebuilds .id AS workspace_id,
70
+ workspace_builds .template_version_preset_id AS current_preset_id
71
71
FROM latest_prebuilds
72
72
JOIN workspace_builds ON workspace_builds .workspace_id = latest_prebuilds .id
73
73
WHERE workspace_builds .transition = ' start' ::workspace_transition
74
+ AND workspace_builds .template_version_preset_id IS NOT NULL
74
75
ORDER BY latest_prebuilds .id , workspace_builds .build_number DESC
75
76
),
76
77
ready_agents AS (
89
90
latest_prebuilds .name ,
90
91
latest_prebuilds .template_id ,
91
92
latest_prebuilds .template_version_id ,
92
- latest_prebuilds . template_version_preset_id AS current_preset_id,
93
+ workspace_latest_presets . current_preset_id ,
93
94
COALESCE(ready_agents .ready , false)::boolean AS ready,
94
95
latest_prebuilds .created_at
95
96
FROM latest_prebuilds
0 commit comments