Skip to content

Commit 0bcdfd5

Browse files
authored
fix: order apps by name (coder#2614)
1 parent a39a856 commit 0bcdfd5

File tree

2 files changed

+6
-6
lines changed

2 files changed

+6
-6
lines changed

coderd/database/queries.sql.go

+3-3
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

coderd/database/queries/workspaceapps.sql

+3-3
Original file line numberDiff line numberDiff line change
@@ -1,14 +1,14 @@
11
-- name: GetWorkspaceAppsByAgentID :many
2-
SELECT * FROM workspace_apps WHERE agent_id = $1;
2+
SELECT * FROM workspace_apps WHERE agent_id = $1 ORDER BY name ASC;
33

44
-- name: GetWorkspaceAppsByAgentIDs :many
5-
SELECT * FROM workspace_apps WHERE agent_id = ANY(@ids :: uuid [ ]);
5+
SELECT * FROM workspace_apps WHERE agent_id = ANY(@ids :: uuid [ ]) ORDER BY name ASC;
66

77
-- name: GetWorkspaceAppByAgentIDAndName :one
88
SELECT * FROM workspace_apps WHERE agent_id = $1 AND name = $2;
99

1010
-- name: GetWorkspaceAppsCreatedAfter :many
11-
SELECT * FROM workspace_apps WHERE created_at > $1;
11+
SELECT * FROM workspace_apps WHERE created_at > $1 ORDER BY name ASC;
1212

1313
-- name: InsertWorkspaceApp :one
1414
INSERT INTO

0 commit comments

Comments
 (0)