coder
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 5 additions & 6 deletions b/‎coderd/database/queries.sql.go
Lines changed: 5 additions & 6 deletions
diff --git a/‎coderd/database/queries/prebuilds.sql
Lines changed: 5 additions & 6 deletions b/‎coderd/database/queries/prebuilds.sql
Lines changed: 5 additions & 6 deletions
@@ -53,13 +53,12 @@ WITH
     latest_prebuilds
         AS (
             SELECT
-	            workspaces.name,
-                workspaces.template_id,
-                latest_build.id,
                 latest_build.workspace_id,
+                workspaces.name,
+                workspaces.template_id,
                 latest_build.template_version_id,
-                latest_build.job_id,
                 latest_build.template_version_preset_id,
+                latest_build.job_id,
                 latest_build.created_at
             FROM
                 workspaces
@@ -101,7 +100,7 @@ WITH
         AS (
             SELECT
                 latest_prebuilds.workspace_id AS workspace_id,
-                BOOL_AND(workspace_agents.lifecycle_state = 'ready'::workspace_agent_lifecycle_state)::boolean AS ready
+                COALESCE(BOOL_AND(workspace_agents.lifecycle_state = 'ready'::workspace_agent_lifecycle_state), false)::boolean AS ready
             FROM
                 latest_prebuilds
                 LEFT JOIN workspace_resources ON
@@ -117,7 +116,7 @@ SELECT
     latest_prebuilds.template_id,
     latest_prebuilds.template_version_id,
     latest_prebuilds.template_version_preset_id AS current_preset_id,
-    COALESCE(agent_readiness.ready, false) AS ready,
+    agent_readiness.ready,
     latest_prebuilds.created_at
 FROM
     latest_prebuilds