query

hugodutka · hugodutka · commit ab3d254c1d69 · 2025-03-20T14:53:38.000Z
diff --git a/coderd/database/modelqueries.go b/coderd/database/modelqueries.go
@@ -393,6 +393,7 @@ func (q *sqlQuerier) GetAuthorizedUsers(ctx context.Context, arg GetUsersParams,
 		arg.LastSeenAfter,
 		arg.CreatedBefore,
 		arg.CreatedAfter,
+		arg.GithubComUserID,
 		arg.OffsetOpt,
 		arg.LimitOpt,
 	)
diff --git a/coderd/database/queries/users.sql b/coderd/database/queries/users.sql
@@ -223,6 +223,11 @@ WHERE
 			created_at >= @created_after
 		ELSE true
 	END
+	AND CASE
+		WHEN @github_com_user_id :: bigint != 0 THEN
+			github_com_user_id = @github_com_user_id
+		ELSE true
+	END
 	-- End of filters
 
 	-- Authorize Filter clause will be injected below in GetAuthorizedUsers

Original file line number	Diff line number	Diff line change
`@@ -393,6 +393,7 @@ func (q *sqlQuerier) GetAuthorizedUsers(ctx context.Context, arg GetUsersParams,`
`393`	`393`	`arg.LastSeenAfter,`
`394`	`394`	`arg.CreatedBefore,`
`395`	`395`	`arg.CreatedAfter,`
	`396`	`+ arg.GithubComUserID,`
`396`	`397`	`arg.OffsetOpt,`
`397`	`398`	`arg.LimitOpt,`
`398`	`399`	`)`