authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_reports_js
Parameters
Name
Type
Mode
report_id
integer
IN
Definition
declare json_options json; _prefix_pms_file_url text; BEGIN /** * Create by KenG (2021/05251) * ******************* * *****For Admin **** * ******************* */ /**{ "report_id": 0, "report_name": "string", "filename": "string", "category": "string", "report_type": "string", "options": {} }**/ select jsonb_agg(dataset) from ( select r.id as report_id, r.report_filename as filename, r.report_name, r.category, r.report_type, r."options" from reports r where id = report_id ) as dataset into json_options; return json_options->0; END;