Skip to content

Commit 3569e56

Browse files
fix: hide deleted users from org members query (cherry-pick #16830) (#16832)
Cherry-picked fix: hide deleted users from org members query (#16830) Co-authored-by: ケイラ <mckayla@hey.com>
1 parent dba881f commit 3569e56

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

coderd/database/queries.sql.go

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

coderd/database/queries/organizationmembers.sql

+1-1
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@ SELECT
99
FROM
1010
organization_members
1111
INNER JOIN
12-
users ON organization_members.user_id = users.id
12+
users ON organization_members.user_id = users.id AND users.deleted = false
1313
WHERE
1414
-- Filter by organization id
1515
CASE

0 commit comments

Comments
 (0)