Remove workspace IDs filter arg

Emyrk · Emyrk · commit 7c9f6861e6fd · 2023-02-07T07:55:52.000-06:00
diff --git a/coderd/database/modelqueries.go b/coderd/database/modelqueries.go
@@ -200,7 +200,6 @@ func (q *sqlQuerier) GetAuthorizedWorkspaces(ctx context.Context, arg GetWorkspa
 	rows, err := q.db.QueryContext(ctx, query,
 		arg.Deleted,
 		arg.Status,
-		pq.Array(arg.WorkspaceIds),
 		arg.OwnerID,
 		arg.OwnerUsername,
 		arg.TemplateName,
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/workspaces.sql b/coderd/database/queries/workspaces.sql
@@ -166,12 +166,6 @@ WHERE
 			END
 		ELSE true
 	END
-	-- Filter by workspace ID
-	AND CASE
-	    WHEN array_length(@workspace_ids :: uuid [ ], 1) > 0 THEN
-	        workspaces.id = ANY(@workspace_ids :: uuid [ ])
-	    ELSE true
-	END
 	-- Filter by owner_id
 	AND CASE
 		WHEN @owner_id :: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
