Skip to content

Commit 3569e56

Browse files
gcp-cherry-pick-bot[bot]aslilac
gcp-cherry-pick-bot[bot]
and
aslilac
authored
fix: hide deleted users from org members query (cherry-pick coder#16830) (coder#16832)
Cherry-picked fix: hide deleted users from org members query (coder#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

Lines changed: 1 addition & 1 deletion
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries/organizationmembers.sql

Lines changed: 1 addition & 1 deletion
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)