fix: order apps by name

f0ssel · f0ssel · commit e159ce5e3880 · 2022-06-23T18:28:32.000Z
diff --git a/coderd/database/queries/workspaceapps.sql b/coderd/database/queries/workspaceapps.sql
@@ -1,14 +1,14 @@
 -- name: GetWorkspaceAppsByAgentID :many
-SELECT * FROM workspace_apps WHERE agent_id = $1;
+SELECT * FROM workspace_apps WHERE agent_id = $1 ORDER BY name ASC;
 
 -- name: GetWorkspaceAppsByAgentIDs :many
-SELECT * FROM workspace_apps WHERE agent_id = ANY(@ids :: uuid [ ]);
+SELECT * FROM workspace_apps WHERE agent_id = ANY(@ids :: uuid [ ]) ORDER BY name ASC;
 
 -- name: GetWorkspaceAppByAgentIDAndName :one
 SELECT * FROM workspace_apps WHERE agent_id = $1 AND name = $2;
 
 -- name: GetWorkspaceAppsCreatedAfter :many
-SELECT * FROM workspace_apps WHERE created_at > $1;
+SELECT * FROM workspace_apps WHERE created_at > $1 ORDER BY name ASC;
 
 -- name: InsertWorkspaceApp :one
 INSERT INTO
