|
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 |
|
|