fix: status filter o users sql

BrunoQuaresma · BrunoQuaresma · commit 9a5a74bc7944 · 2022-04-28T13:36:55.000Z
diff --git a/coderd/database/queries/users.sql b/coderd/database/queries/users.sql
@@ -81,6 +81,8 @@ WHERE
 			email LIKE concat('%', @search, '%')
 			OR username LIKE concat('%', @search, '%')
 		)	
+		ELSE true
+	AND CASE
 		WHEN @status :: user_status != '' THEN (
 			status = @status
 		)

Original file line number	Diff line number	Diff line change
`@@ -81,6 +81,8 @@ WHERE`
`81`	`81`	`email LIKE concat('%', @search, '%')`
`82`	`82`	`OR username LIKE concat('%', @search, '%')`
`83`	`83`	`)`
	`84`	`+ ELSE true`
	`85`	`+ AND CASE`
`84`	`86`	`WHEN @status :: user_status != '' THEN (`
`85`	`87`	`status = @status`
`86`	`88`	`)`