aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_bedtype_js
Parameters
Name
Type
Mode
Definition
declare json_result json; _prefix_pms_file_url text; begin --fn_prop_config can't test from stored procedure because pass str_conn from nodeJS select config_value from fn_prop_config(null, 'PREFIX_URL_PMS_FILE', '') into _prefix_pms_file_url; select jsonb_agg(dataset) from ( SELECT bt.id, bt."name", bt.enabled, bt.code, coalesce( case when (bt.image is null) then null else _prefix_pms_file_url || bt.image_url end ) as image_url FROM bed_type bt ) as dataset into json_result; return json_result; END;