aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_nbis_cm_config
Parameters
Name
Type
Mode
Definition
SELECT jsonb_build_object( 'code', c.code, 'enabled', coalesce(c.enabled, false), 'endpoint', nullif(btrim(coalesce(c.configs->>'ENDPOINT', '')), ''), 'api_key', nullif(coalesce(c.configs->>'API-KEY', ''), ''), 'property_id', nullif(btrim(coalesce(c.configs->>'PROPERTY_ID', '')), '') ) FROM ( SELECT nullif(btrim(coalesce(i.configs->>'INTERFACE_CODE', '')), '') AS code FROM interfaces i WHERE i.code = 'NBIS' ) n LEFT JOIN interfaces c ON n.code IS NOT NULL AND c.code = n.code