authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_user_group_ids
Parameters
Name
Type
Mode
user_id
integer
IN
prop_id
integer
IN
Definition
SELECT COALESCE(array_agg(DISTINCT gid), ARRAY[]::integer[]) FROM ( SELECT ur.group_id AS gid FROM public.user_roles ur WHERE ur.user_id = $1 AND ur.prop_id = $2 AND ur.active UNION SELECT u.user_group_id FROM public.users u JOIN public.user_property up ON up.user_id = u.id AND up.prop_id = $2 WHERE u.id = $1 AND u.user_group_id IS NOT NULL AND NOT EXISTS ( SELECT 1 FROM public.user_roles ur WHERE ur.user_id = $1 AND ur.prop_id = $2 AND ur.active ) ) s;