authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_reports_option_js
Parameters
Name
Type
Mode
report_id
integer
IN
Definition
declare json_options json; begin /** * Create by KenG (2021/04/01) * ************************************* * *****For PMS DB and Admin service**** * ************************************* */ -- Get JSON from field options select "options" from reports where id = report_id into json_options; return json_options; END;