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

Commite8aa9ac

Browse files
committed
fix query to not limit
1 parentca5b504 commite8aa9ac

File tree

2 files changed

+3
-7
lines changed

2 files changed

+3
-7
lines changed

‎coderd/database/queries.sql.go

Lines changed: 1 addition & 3 deletions
Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

‎coderd/database/queries/organizationmembers.sql

Lines changed: 2 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -14,14 +14,12 @@ WHERE
1414
organization_id= @organization_id
1515
ELSE true
1616
END
17-
-- Filter byorganization id
17+
-- Filter byuser id
1818
AND CASE
1919
WHEN @user_id :: uuid!='00000000-0000-0000-0000-000000000000'::uuid THEN
2020
user_id= @user_id
2121
ELSE true
22-
END
23-
LIMIT
24-
1;
22+
END;
2523

2624
-- name: InsertOrganizationMember :one
2725
INSERT INTO

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp