aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_consent_master_list
Parameters
Name
Type
Mode
p_active_only
boolean
IN (DEFAULT false)
Definition
SELECT COALESCE(json_agg( jsonb_build_object( 'id', cm.id, 'consent_key', cm.consent_key, 'is_required', cm.is_required, 'is_active', cm.is_active, 'version', cm.version, 'create_at', cm.create_at, 'details', COALESCE(( SELECT json_agg( jsonb_build_object( 'id', cd.id, 'lang_code', cd.lang_code, 'title', cd.title, 'content_body', cd.content_body, 'update_at', cd.update_at ) ORDER BY cd.lang_code ) FROM public.consent_details cd WHERE cd.consent_master_id = cm.id ), '[]'::json) ) ORDER BY cm.id ), '[]'::json) FROM public.consent_master cm WHERE NOT p_active_only OR cm.is_active