Commit20d1cb3

committed

fix: Filter by deleted when querying workspaces

1 parentabf14d9 commit20d1cb3Copy full SHA for 20d1cb3

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -109,15 +109,15 @@ WHERE`
`109`	`109`	`-- Filter by owner_name`
`110`	`110`	`AND CASE`
`111`	`111`	`WHEN @owner_username ::text!='' THEN`
`112`		`-owner_id= (SELECT idFROM usersWHERElower(username)=lower(@owner_username))`
	`112`	`+owner_id= (SELECT idFROM usersWHERElower(username)=lower(@owner_username)AND deleted= false)`
`113`	`113`	`ELSE true`
`114`	`114`	`END`
`115`	`115`	`-- Filter by template_name`
`116`	`116`	`-- There can be more than 1 template with the same name across organizations.`
`117`	`117`	`-- Use the organization filter to restrict to 1 org if needed.`
`118`	`118`	`AND CASE`
`119`	`119`	`WHEN @template_name ::text!='' THEN`
`120`		`-template_id= ANY(SELECT idFROM templatesWHERElower(name)=lower(@template_name))`
	`120`	`+template_id= ANY(SELECT idFROM templatesWHERElower(name)=lower(@template_name)AND deleted= false)`
`121`	`121`	`ELSE true`
`122`	`122`	`END`
`123`	`123`	`-- Filter by template_ids`

Comments

(0)