aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_consent_details_list
Parameters
Name
Type
Mode
p_consent_master_id
integer
IN (DEFAULT NULL)
p_lang_code
text
IN (DEFAULT NULL)
Definition
SELECT COALESCE(json_agg(d ORDER BY d.consent_master_id, d.lang_code), '[]'::json) FROM public.consent_details d WHERE (p_consent_master_id IS NULL OR d.consent_master_id = p_consent_master_id) AND (p_lang_code IS NULL OR d.lang_code = p_lang_code)