File tree Expand file tree Collapse file tree 1 file changed +14
-14
lines changed Expand file tree Collapse file tree 1 file changed +14
-14
lines changed Original file line number Diff line number Diff line change 28
28
WHERE
29
29
true
30
30
AND CASE
31
- WHEN @organization_id:: uuid != ' 00000000-0000-0000-0000-000000000000' ::uuid THEN
32
- groups .organization_id = @organization_id
33
- ELSE true
31
+ WHEN @organization_id:: uuid != ' 00000000-0000-0000-0000-000000000000' ::uuid THEN
32
+ groups .organization_id = @organization_id
33
+ ELSE true
34
34
END
35
35
AND CASE
36
36
-- Filter to only include groups a user is a member of
37
37
WHEN @has_member_id::uuid != ' 00000000-0000-0000-0000-000000000000' ::uuid THEN
38
38
EXISTS (
39
- SELECT
40
- 1
41
- FROM
42
- -- this view handles the 'everyone' group in orgs.
43
- group_members_expanded
44
- WHERE
45
- group_members_expanded .group_id = groups .id
46
- AND
47
- group_members_expanded .user_id = @has_member_id
48
- )
49
- ELSE true
39
+ SELECT
40
+ 1
41
+ FROM
42
+ -- this view handles the 'everyone' group in orgs.
43
+ group_members_expanded
44
+ WHERE
45
+ group_members_expanded .group_id = groups .id
46
+ AND
47
+ group_members_expanded .user_id = @has_member_id
48
+ )
49
+ ELSE true
50
50
END
51
51
;
52
52
You can’t perform that action at this time.
0 commit comments