Skip to content

Commit 3caa9d5

Browse files
EmyrkEmyrk
committed
exclude deleted workspaces'
1 parent 5dcc74f commit 3caa9d5

File tree

2 files changed

+2
-0
lines changed

2 files changed

+2
-0
lines changed

‎coderd/database/queries.sql.go

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

‎coderd/database/queries/quotas.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -30,6 +30,7 @@ INNER JOIN
3030
WHERE
3131
-- Only return workspaces that match the user + organization.
3232
-- Quotas are calculated per user per organization.
33+
NOT workspaces.deleted AND
3334
workspaces.owner_id = @owner_id AND
3435
workspaces.organization_id = @organization_id
3536
ORDER BY

0 commit comments

Comments
 (0)