aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_reports_list_js
Parameters
Name
Type
Mode
i_prefix_url_pms_file
text
IN (DEFAULT NULL)
Definition
declare strcurrent_propcode text; json_result json; sql_text text; --user_id int; begin /** * Create by KenG (2020/08/31) * This stored procedure will get and return json to PMS service(NodeJS) * Select report list from Authen DB base on propcode * Stored procedure: sp_get_reports_list_js(propcode citext) from authen DB * - Will get list report name base on prop_code * - If want to edit logic that edit sp_get_reports_list_js(propcode citext) from authen DB * ----- * Update (2021/05/25) * i_prefix_url_pms_file for develop pass value from NodeJS */ strcurrent_propcode = fn_current_propcode(); --raise notice 'i_prefix_url_pms_file1: %', i_prefix_url_pms_file; sql_text = format('SELECT * FROM sp_get_reports_list_js(%L, %L, %L)', strcurrent_propcode, i_prefix_url_pms_file, fn_current_user()); --PERFORM sp_sys_log('sp_get_reports_list_js', format('user_id = %L, user_name = %L', fn_get_session('user_id', 'NULL'), fn_get_session('user_name', 'NULL'))); --raise notice 'i_prefix_url_pms_file2: %', sql_text; select obj_params from dblink(fn_conn_authen(), sql_text) as params(obj_params json) into json_result; return json_result; END;