Add name in missing parts

BrunoQuaresma · BrunoQuaresma · commit 9d5f6d84a13b · 2025-05-27T13:59:55.000Z
diff --git a/coderd/database/migrations/000330_workspace_with_correct_owner_names.up.sql b/coderd/database/migrations/000330_workspace_with_correct_owner_names.up.sql
@@ -40,7 +40,7 @@ SELECT
     COALESCE(
         visible_users.username,
         ''::text
-    ) AS initiator_by_username
+    ) AS initiator_by_username COALESCE(visible_users.name, ''::text) AS initiator_by_name
 FROM (
         workspace_builds
         LEFT JOIN visible_users ON (
@@ -92,6 +92,7 @@ SELECT
         visible_users.username,
         ''::text
     ) AS created_by_username,
+    COALESCE(visible_users.name, ''::text) AS created_by_name,
     COALESCE(organizations.name, ''::text) AS organization_name,
     COALESCE(
         organizations.display_name,
@@ -139,7 +140,7 @@ SELECT
     COALESCE(
         visible_users.username,
         ''::text
-    ) AS created_by_username
+    ) AS created_by_username COALESCE(visible_users.name, ''::text) AS created_by_name
 FROM (
         template_versions
         LEFT JOIN visible_users ON (
