Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit87f4c48

Browse files
committed
query
1 parent63b5f0b commit87f4c48

File tree

1 file changed

+15
-0
lines changed

1 file changed

+15
-0
lines changed

‎coderd/database/queries/workspacebuildparameters.sql

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -41,3 +41,18 @@ FROM (
4141
) q1
4242
ORDER BY created_atDESC, name
4343
LIMIT100;
44+
45+
-- name: GetWorkspaceBuildParametersByBuildIDs :many
46+
SELECT
47+
workspace_build_parameters.*
48+
FROM
49+
workspace_build_parameters
50+
JOIN
51+
workspace_buildsONworkspace_builds.id=workspace_build_parameters.workspace_build_id
52+
JOIN
53+
workspacesONworkspaces.id=workspace_builds.workspace_id
54+
WHERE
55+
workspace_build_parameters.workspace_build_id= ANY(@workspace_build_ids :: uuid[])
56+
-- Authorize Filter clause will be injected below in GetAuthorizedWorkspaceBuildParametersByBuildIDs
57+
-- @authorize_filter
58+
;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp