Oct 28, 2025 · Oct 24, 2025 · Oct 28, 2025 · Oct 28, 2025
diff --git a/coderd/aitasks.go b/coderd/aitasks.go
 ID:dbTask.ID,
 OrganizationID:dbTask.OrganizationID,
 OwnerID:dbTask.OwnerID,
 OwnerName:ws.OwnerName,
 OwnerAvatarURL:ws.OwnerAvatarURL,
 OwnerName:dbTask.OwnerUsername,
 OwnerAvatarURL:dbTask.OwnerAvatarUrl,
 Name:dbTask.Name,
 TemplateID:ws.TemplateID,
 TemplateVersionID:dbTask.TemplateVersionID,
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000391_tasks_with_status_user_fields.down.sql b/coderd/database/migrations/000391_tasks_with_status_user_fields.down.sql
 -- Drop view from 000390_tasks_with_status_user_fields.up.sql.
 DROP VIEW IF EXISTS tasks_with_status;

 -- Restore from 000382_add_columns_to_tasks_with_status.up.sql.
 CREATE VIEW
 tasks_with_status
 AS
 SELECT
 tasks.*,
 CASE
 WHEN tasks.workspace_id IS NULL OR latest_build.job_status IS NULL THEN 'pending'::task_status

 WHEN latest_build.job_status = 'failed' THEN 'error'::task_status

 WHEN latest_build.transition IN ('stop', 'delete')
 AND latest_build.job_status = 'succeeded' THEN 'paused'::task_status

 WHEN latest_build.transition = 'start'
 AND latest_build.job_status = 'pending' THEN 'initializing'::task_status

 WHEN latest_build.transition = 'start' AND latest_build.job_status IN ('running', 'succeeded') THEN
 CASE
 WHEN agent_status.none THEN 'initializing'::task_status
 WHEN agent_status.connecting THEN 'initializing'::task_status
 WHEN agent_status.connected THEN
 CASE
 WHEN app_status.any_unhealthy THEN 'error'::task_status
 WHEN app_status.any_initializing THEN 'initializing'::task_status
 WHEN app_status.all_healthy_or_disabled THEN 'active'::task_status
 ELSE 'unknown'::task_status
 END
 ELSE 'unknown'::task_status
 END

 ELSE 'unknown'::task_status
 END AS status,
 task_app.*
 FROM
 tasks
 LEFT JOIN LATERAL (
 SELECT workspace_build_number, workspace_agent_id, workspace_app_id
 FROM task_workspace_apps task_app
 WHERE task_id = tasks.id
 ORDER BY workspace_build_number DESC
 LIMIT 1
 ) task_app ON TRUE
 LEFT JOIN LATERAL (
 SELECT
 workspace_build.transition,
 provisioner_job.job_status,
 workspace_build.job_id
 FROM workspace_builds workspace_build
 JOIN provisioner_jobs provisioner_job ON provisioner_job.id = workspace_build.job_id
 WHERE workspace_build.workspace_id = tasks.workspace_id
 AND workspace_build.build_number = task_app.workspace_build_number
 ) latest_build ON TRUE
 CROSS JOIN LATERAL (
 SELECT
 COUNT(*) = 0 AS none,
 bool_or(workspace_agent.lifecycle_state IN ('created', 'starting')) AS connecting,
 bool_and(workspace_agent.lifecycle_state = 'ready') AS connected
 FROM workspace_agents workspace_agent
 WHERE workspace_agent.id = task_app.workspace_agent_id
 ) agent_status
 CROSS JOIN LATERAL (
 SELECT
 bool_or(workspace_app.health = 'unhealthy') AS any_unhealthy,
 bool_or(workspace_app.health = 'initializing') AS any_initializing,
 bool_and(workspace_app.health IN ('healthy', 'disabled')) AS all_healthy_or_disabled
 FROM workspace_apps workspace_app
 WHERE workspace_app.id = task_app.workspace_app_id
 ) app_status
 WHERE
 tasks.deleted_at IS NULL;
diff --git a/coderd/database/migrations/000391_tasks_with_status_user_fields.up.sql b/coderd/database/migrations/000391_tasks_with_status_user_fields.up.sql
 -- Drop view from 00037_add_columns_to_tasks_with_status.up.sql.
 DROP VIEW IF EXISTS tasks_with_status;

 -- Add owner_name, owner_avatar_url columns.
 CREATE VIEW
 tasks_with_status
 AS
 SELECT
 tasks.*,
 CASE
 WHEN tasks.workspace_id IS NULL OR latest_build.job_status IS NULL THEN 'pending'::task_status

 WHEN latest_build.job_status = 'failed' THEN 'error'::task_status

 WHEN latest_build.transition IN ('stop', 'delete')
 AND latest_build.job_status = 'succeeded' THEN 'paused'::task_status

 WHEN latest_build.transition = 'start'
 AND latest_build.job_status = 'pending' THEN 'initializing'::task_status

 WHEN latest_build.transition = 'start' AND latest_build.job_status IN ('running', 'succeeded') THEN
 CASE
 WHEN agent_status.none THEN 'initializing'::task_status
 WHEN agent_status.connecting THEN 'initializing'::task_status
 WHEN agent_status.connected THEN
 CASE
 WHEN app_status.any_unhealthy THEN 'error'::task_status
 WHEN app_status.any_initializing THEN 'initializing'::task_status
 WHEN app_status.all_healthy_or_disabled THEN 'active'::task_status
 ELSE 'unknown'::task_status
 END
 ELSE 'unknown'::task_status
 END

 ELSE 'unknown'::task_status
 END AS status,
 task_app.*,
 task_owner.*
 FROM
 tasks
 CROSS JOIN LATERAL (
 SELECT
 vu.username AS owner_username,
 vu.name AS owner_name,
 vu.avatar_url AS owner_avatar_url
 FROM visible_users vu
 WHERE vu.id = tasks.owner_id
 ) task_owner
 LEFT JOIN LATERAL (
 SELECT workspace_build_number, workspace_agent_id, workspace_app_id
 FROM task_workspace_apps task_app
 WHERE task_id = tasks.id
 ORDER BY workspace_build_number DESC
 LIMIT 1
 ) task_app ON TRUE
 LEFT JOIN LATERAL (
 SELECT
 workspace_build.transition,
 provisioner_job.job_status,
 workspace_build.job_id
 FROM workspace_builds workspace_build
 JOIN provisioner_jobs provisioner_job ON provisioner_job.id = workspace_build.job_id
 WHERE workspace_build.workspace_id = tasks.workspace_id
 AND workspace_build.build_number = task_app.workspace_build_number
 ) latest_build ON TRUE
 CROSS JOIN LATERAL (
 SELECT
 COUNT(*) = 0 AS none,
 bool_or(workspace_agent.lifecycle_state IN ('created', 'starting')) AS connecting,
 bool_and(workspace_agent.lifecycle_state = 'ready') AS connected
 FROM workspace_agents workspace_agent
 WHERE workspace_agent.id = task_app.workspace_agent_id
 ) agent_status
 CROSS JOIN LATERAL (
 SELECT
 bool_or(workspace_app.health = 'unhealthy') AS any_unhealthy,
 bool_or(workspace_app.health = 'initializing') AS any_initializing,
 bool_and(workspace_app.health IN ('healthy', 'disabled')) AS all_healthy_or_disabled
 FROM workspace_apps workspace_app
 WHERE workspace_app.id = task_app.workspace_app_id
 ) app_status
 WHERE
 tasks.deleted_at IS NULL;

diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
Original file line number	Diff line number	Diff line change
Expand Up		@@ -339,8 +339,8 @@ func taskFromDBTaskAndWorkspace(dbTask database.Task, ws codersdk.Workspace) cod
		ID:dbTask.ID,
		OrganizationID:dbTask.OrganizationID,
		OwnerID:dbTask.OwnerID,
		OwnerName:ws.OwnerName,
		OwnerAvatarURL:ws.OwnerAvatarURL,
		OwnerName:dbTask.OwnerUsername,
		OwnerAvatarURL:dbTask.OwnerAvatarUrl,
		Name:dbTask.Name,
		TemplateID:ws.TemplateID,
		TemplateVersionID:dbTask.TemplateVersionID,
Expand Down
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,74 @@
		-- Drop view from 000390_tasks_with_status_user_fields.up.sql.
		DROP VIEW IF EXISTS tasks_with_status;

		-- Restore from 000382_add_columns_to_tasks_with_status.up.sql.
		CREATE VIEW
		tasks_with_status
		AS
		SELECT
		tasks.*,
		CASE
		WHEN tasks.workspace_id IS NULL OR latest_build.job_status IS NULL THEN 'pending'::task_status

		WHEN latest_build.job_status = 'failed' THEN 'error'::task_status

		WHEN latest_build.transition IN ('stop', 'delete')
		AND latest_build.job_status = 'succeeded' THEN 'paused'::task_status

		WHEN latest_build.transition = 'start'
		AND latest_build.job_status = 'pending' THEN 'initializing'::task_status

		WHEN latest_build.transition = 'start' AND latest_build.job_status IN ('running', 'succeeded') THEN
		CASE
		WHEN agent_status.none THEN 'initializing'::task_status
		WHEN agent_status.connecting THEN 'initializing'::task_status
		WHEN agent_status.connected THEN
		CASE
		WHEN app_status.any_unhealthy THEN 'error'::task_status
		WHEN app_status.any_initializing THEN 'initializing'::task_status
		WHEN app_status.all_healthy_or_disabled THEN 'active'::task_status
		ELSE 'unknown'::task_status
		END
		ELSE 'unknown'::task_status
		END

		ELSE 'unknown'::task_status
		END AS status,
		task_app.*
		FROM
		tasks
		LEFT JOIN LATERAL (
		SELECT workspace_build_number, workspace_agent_id, workspace_app_id
		FROM task_workspace_apps task_app
		WHERE task_id = tasks.id
		ORDER BY workspace_build_number DESC
		LIMIT 1
		) task_app ON TRUE
		LEFT JOIN LATERAL (
		SELECT
		workspace_build.transition,
		provisioner_job.job_status,
		workspace_build.job_id
		FROM workspace_builds workspace_build
		JOIN provisioner_jobs provisioner_job ON provisioner_job.id = workspace_build.job_id
		WHERE workspace_build.workspace_id = tasks.workspace_id
		AND workspace_build.build_number = task_app.workspace_build_number
		) latest_build ON TRUE
		CROSS JOIN LATERAL (
		SELECT
		COUNT(*) = 0 AS none,
		bool_or(workspace_agent.lifecycle_state IN ('created', 'starting')) AS connecting,
		bool_and(workspace_agent.lifecycle_state = 'ready') AS connected
		FROM workspace_agents workspace_agent
		WHERE workspace_agent.id = task_app.workspace_agent_id
		) agent_status
		CROSS JOIN LATERAL (
		SELECT
		bool_or(workspace_app.health = 'unhealthy') AS any_unhealthy,
		bool_or(workspace_app.health = 'initializing') AS any_initializing,
		bool_and(workspace_app.health IN ('healthy', 'disabled')) AS all_healthy_or_disabled
		FROM workspace_apps workspace_app
		WHERE workspace_app.id = task_app.workspace_app_id
		) app_status
		WHERE
		tasks.deleted_at IS NULL;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,84 @@
		-- Drop view from 00037_add_columns_to_tasks_with_status.up.sql.
		DROP VIEW IF EXISTS tasks_with_status;

		-- Add owner_name, owner_avatar_url columns.
		CREATE VIEW
		tasks_with_status
		AS
		SELECT
		tasks.*,
		CASE
		WHEN tasks.workspace_id IS NULL OR latest_build.job_status IS NULL THEN 'pending'::task_status

		WHEN latest_build.job_status = 'failed' THEN 'error'::task_status

		WHEN latest_build.transition IN ('stop', 'delete')
		AND latest_build.job_status = 'succeeded' THEN 'paused'::task_status

		WHEN latest_build.transition = 'start'
		AND latest_build.job_status = 'pending' THEN 'initializing'::task_status

		WHEN latest_build.transition = 'start' AND latest_build.job_status IN ('running', 'succeeded') THEN
		CASE
		WHEN agent_status.none THEN 'initializing'::task_status
		WHEN agent_status.connecting THEN 'initializing'::task_status
		WHEN agent_status.connected THEN
		CASE
		WHEN app_status.any_unhealthy THEN 'error'::task_status
		WHEN app_status.any_initializing THEN 'initializing'::task_status
		WHEN app_status.all_healthy_or_disabled THEN 'active'::task_status
		ELSE 'unknown'::task_status
		END
		ELSE 'unknown'::task_status
		END

		ELSE 'unknown'::task_status
		END AS status,
		task_app.*,
		task_owner.*
		FROM
		tasks
		CROSS JOIN LATERAL (
		SELECT
		vu.username AS owner_username,
		vu.name AS owner_name,
		vu.avatar_url AS owner_avatar_url
		FROM visible_users vu
		WHERE vu.id = tasks.owner_id
		) task_owner
		LEFT JOIN LATERAL (
		SELECT workspace_build_number, workspace_agent_id, workspace_app_id
		FROM task_workspace_apps task_app
		WHERE task_id = tasks.id
		ORDER BY workspace_build_number DESC
		LIMIT 1
		) task_app ON TRUE
		LEFT JOIN LATERAL (
		SELECT
		workspace_build.transition,
		provisioner_job.job_status,
		workspace_build.job_id
		FROM workspace_builds workspace_build
		JOIN provisioner_jobs provisioner_job ON provisioner_job.id = workspace_build.job_id
		WHERE workspace_build.workspace_id = tasks.workspace_id
		AND workspace_build.build_number = task_app.workspace_build_number
		) latest_build ON TRUE
		CROSS JOIN LATERAL (
		SELECT
		COUNT(*) = 0 AS none,
		bool_or(workspace_agent.lifecycle_state IN ('created', 'starting')) AS connecting,
		bool_and(workspace_agent.lifecycle_state = 'ready') AS connected
		FROM workspace_agents workspace_agent
		WHERE workspace_agent.id = task_app.workspace_agent_id
		) agent_status
		CROSS JOIN LATERAL (
		SELECT
		bool_or(workspace_app.health = 'unhealthy') AS any_unhealthy,
		bool_or(workspace_app.health = 'initializing') AS any_initializing,
		bool_and(workspace_app.health IN ('healthy', 'disabled')) AS all_healthy_or_disabled
		FROM workspace_apps workspace_app
		WHERE workspace_app.id = task_app.workspace_app_id
		) app_status
		WHERE
		tasks.deleted_at IS NULL;